hany_3210
October 8th, 2005, 04:46 AM
hey digital youth.
i have a problem in sql server.
simply u can make concatenation in sql server using + operator
ex:
select * from emp where ename like '%'+@name+'%'
this works normaly when name variable is of char or varchar data type.
but problem fires when name vairable is of ntext data type.
how can i make concatination ntext variable with string . how????
thx all
i have a problem in sql server.
simply u can make concatenation in sql server using + operator
ex:
select * from emp where ename like '%'+@name+'%'
this works normaly when name variable is of char or varchar data type.
but problem fires when name vairable is of ntext data type.
how can i make concatination ntext variable with string . how????
thx all