Posted by SQL on 10/02/88 11:47

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

• Next in forum: String matching precedence
• Prev in forum: Re: ANSI Nulls
• Thread view: Re: How can I insert # in a character field

[Reply to this message]