Posted by shark on 07/04/06 14:20

Hi All,

i hv created a sp as


Create proc P @iClientid varchar (100)
as
Begin
select * from clients where CONVERT(VACHAR(100),iClientid) in(
@iclientid)
end

where iclientid = int data type in the clients table.
now if i pass @iclientid as @iclientid = '49,12,112'

but this statement throws an conversion error ( int to char error).

is there any way to fetch records from a select statement using a
string???

Thanks in Advance.

[Back to original message]