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.
| Author |
Topic |
|
veparala
Starting Member
30 Posts |
 Posted - 2007-06-11 : 11:02:16
|
| Hi I would like to know whether plus sign ( '+' sign) is alphanumeric or not?.Can anybody help me? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-11 : 11:06:54
|
| It is a special characterMadhivananFailing to plan is Planning to fail |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-11 : 11:11:50
|
| Depends on your usage.Alphanumeric can just be 0-9, a-z.Can include other characters depending on the application.A lot of isnumeric functions will say that - and + are numeric characters (same with . and ,)==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2007-06-11 : 11:51:18
|
quote:
Originally posted by nrA lot of isnumeric functions will say that - and + are numeric characters (same with . and ,)
So are the currency symbols and the non-breaking space.Not to mention the infinity symbol, the line-draw characters and U+263C (White Sun With Rays), all because ISNUMERIC does an implicit conversion to varchar before testing. (Infinity converts to 8, BTW)  |
|
|
|
|
|
|
'+' sign is Alphanumeric?