'TRIM' is not a recognized built-in function name

Question

I have created simple function

create function TRIM(@data varchar(20)) returns varchar(100) as begin   declare @str varchar(20)   set @str = rtrim(ltrim(@data))   return @str end 

I am executing in the below way.

declare @s varchar(25) set @s = '      Amru    ' select TRIM(@s) 

I am getting the following error.

Msg 195, Level 15, State 10, Line 3 'TRIM' is not a recognized built-in function name. 

Could any one please help me find the issue?

Answer 1

//use RTrim instead of Trim sql 2008 

RTrim(ColumnName)

like this

select RTrim(a.ContactName) + ' ' + RTrim(a.City) as Name_City from customers as a 

Answer 2

declare @s varchar(25) set @s = '      Amru    ' select RTRIM(LTRIM(@s))   

You can use this way also without schema :)