Hi List,

I remember for SQL 7, char(?) is actually equal to single quote, so in a query, if I need to put single quotes around char column, I just put

char(?) + column_name + char(?) which will become 'column_name' in the final query.

However, this doesn't work for sql2k. Any idea why?

Also, how can I find a list of char() items and what they are for? i.e. char(?) for single quote?

Thanks a lot,

Elaine








MS Sql Server LazyDBA home page