Posted by Robert Klemme on 07/04/06 15:30

shark wrote:
> 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)

This does not work as you probably want. You get a selection criterium
with a single string @iClientid. You could have written

select * from clients where CONVERT(VACHAR(100),iClientid) = @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???

If you need to pass in your id's the way you do, you can do it with
dynamic SQL, i.e. create a SQL statement and EXEC it.

robert

[Back to original message]