Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by DWSRAMBO
-
SQL - Convert a 9 byte Character column to an Integer
I am trying to convert a 9 digit character column to an integer column. I'm not sure whether the field has spaces or non-numeric characters. I can Ltrim/Rtrim the spaces off either end before converting but if there are spaces or non-numeric characters within I need to make the resulting...- DWSRAMBO
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
How to get date without conversion?
Just wanted to thank you for your response to my question this afternoon and was unsure how to get this message to you(New user). It worked great. Thanks Again Rich- DWSRAMBO
- Post #12
- Forum: Microsoft SQL Server: Programming
-
Dropping leading zeros when adding 1 to a 3 pos char column
Greetings, I have a question regarding what I think is probably a fairly basic question but through a couple hours of trying various things (including cast, convert, and a host of others) I have been unable to come up with an answer. For this example I have cut pertinent information out of the...- DWSRAMBO
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
