>Thanks a mil. I'll check it out pronto.
>
>By the way do you know how i can include strings which contains an apostrophe ???
>
> eg. Christopher's Egg. The apostrophe would normally give an error. I wrote a routine to remove them automatically when typed in the text box. The ideal situation would be to include those apostrophe.

Do you mean something like this:

«
When QUOTED_IDENTIFIER is OFF, SQL Server follows these rules for the use of double and single quotation marks:

Quotation marks cannot be used to delimit identifiers. Instead, use brackets as delimiters.
Either single or double quotation marks can be used to enclose character strings.
If double quotation marks are used, embedded single quotation marks do not have to be denoted by two single quotation marks:

SELECT * FROM [My Table]

WHERE [Last Name] = "O'Brien"

»

I took this from Books OnLine