Those values passed as a string (user types those values comma separated inside the text box) from application and then i suppose to search the database for the records passed.

Sure, this is what i used:

declare @List VARCHAR(100)

set @List = 'abc,xyz,kty'

set @List = '''' + REPLACE(REPLACE(@List, '''', ''''''), ',', ''',''') + ''''

print @List

If you think i don't research then you are mistaken.I don't take anything for granted.

It doesn't work in my case because the values are not coming from the table , they...

Thank you, but in my case i don't have a string as the original values.

I tried and got Invalid column name  error

Thanks so much

Another question:

If i want to find if the string has spaces between words how can i do it?

i tried to use charindex but it always returns 0 for this example:

'Cx...

Thanks you so much.

Thank you so much

No, i am not sure.

We have 4 steps in a job like:

step 1: dbcc checkdb (checks 1st db&nbsp -- this step always success

if all...

Thank you for reply, is this a special software i have to use for a merge?

Thank you all for reply's, it's interesting that sometimes the simple copy from production to adhoc server also fails. Sysadmin will replace the network  card today and...

Thank you for reply,

Ok, 98GB is the total of the database size including empty spaces for data and log files.

The total size on adhoc server available is 450GB