How to store   in MSSQL7 table?

[thainjm]

Hi,

I need to put the non-breaking space character as the default value for the cells in table if they are left blank, so that my web page displays properly (see the problem at

http://crowhurst.dns2go.com/lbdb/samples.asp).

How do I do it? I tried   but SQL puts brackets round it, and it doesn't seem to work.

Thanks,

Jason.

 

[tlbroadbent]

Did you enclose the string in single quotes? ' '

SQL shows the parentheses on display but the parentheses are not inserted into the table. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.