By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,787 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

How can I insert # in a character field

P: n/a
Hello,

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

Thanks

May 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SQL
# 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/

May 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.