Hello ,

I have a table with Diagnosis as a Field and the values in it look like "90,105" , the comma separated ids are th diagnosis ids, now I want to fetch the diagnosis names from the diagnosis main table for all the values in the comma separated field Diagnosis .

please help me in this as it is very urgent requirment.

regards
sasidhar

thanks,
Sasidhar

__________________
thanks,
Sasidhar

I have a suggestion,

If you are using Stored Procedure, you can convert the filed value from "90,105" into '90','105',

Use either Exists or Inlist.


Gokulan Ethiraj

if your comma seperated values are integer type then you can use exec command to get your job done

like
exec ('select whatever from Tablename where column in (' + cast(commaseperatedvalue as varchar) +')')

atul