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 |
|
jgrant
Yak Posting Veteran
69 Posts |
 Posted - 2007-03-21 : 20:26:05
|
| how can you return part of a string and convert it into an integer value? Maybe like this:convert(left(column, 3) as int)does that work?The Yak Village Idiot |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-21 : 21:49:03
|
provided that the string are numbers. Just give it a try. Don't worry, it won't blow up your server.
KH |
 |
|
|
|
|
|
return part of a string