allowing + in field - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

allowing + in field

Author

Topic

jmarksamer
Starting Member

2 Posts

Posted - 2007-08-20 : 10:56:31

how can i setup an input field and SQL column to allow a user to enter something such as: '1+' into the field and the db? i get an error due to the '+'.

X002548
Not Just a Number

15586 Posts

Posted - 2007-08-20 : 11:16:09

DECLARE @x char(2)
SET @x = '1+'
SELECT @x

Not really sure what you're trying to do though

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources