How can I insert # in a character field

[sweetpotatop@yahoo.com]

Hello,

I wonder how I can insert a string which contains #, as # is a special
characters in sql

Thanks

[SQL]

Re: How can I insert # in a character field

# is not special, take a look at this

Create Table #TableQ (CharColumn varchar(51))

insert into #TableQ values('#')
insert into #TableQ values('######' )
insert into #TableQ values('*&^%$#@ ')

select * from #TableQ

We are talking about SQL server right, not Access?

Denis the SQL Menace

http://sqlservercode.blogspot.com/