How can I insert # in a character field

Hello,

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

Thanks# 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/