Regarding...
Hi.. i hav a string like this in (select convert(varchar,value) from split(class,',')) In need to print like this while executing the below code .. can u help me??? declare @common varchar(50); set @common='in (select convert(varchar,value) from split(class,''','''))' print @common;
please refer this...
declare @common varchar(100);
set @common='in (select convert(varchar,value) from split(class,'',''))'
print @common;
what i chnage is increase the size of
@common
to
100
and remove one quot from
''','''
result will be like this...
in (select convert(varchar,value) from split(class,','))