Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Convert Varchar to Decimal Rate Topic Display Mode Topic Options
Author
 Message
 Posted Thursday, February 14, 2013 8:43 PM
 Ten Centuries Group: General Forum Members Last Login: Monday, June 6, 2016 1:51 PM Points: 1,400, Visits: 3,059
 Went looking on the net and found an answer right here in SSC (of course!!). If you want to test for all digits, the expression NOT LIKE '%[^0-9]%' should do it. Do read the entire post from Jeff Moden about testing for numbers.
Post #1420367
 Posted Thursday, February 14, 2013 9:50 PM
 SSC Journeyman Group: General Forum Members Last Login: Tuesday, September 20, 2016 9:43 PM Points: 88, Visits: 355
 PATINDEX('%[^0-9]%', LHP_PARAM_RESULT_VALUE) = 0I am just mentioned a name only.
Post #1420372
 Posted Thursday, February 14, 2013 9:53 PM
 SSC Journeyman Group: General Forum Members Last Login: Tuesday, September 20, 2016 9:43 PM Points: 88, Visits: 355
 PATINDEX('%[^0-9]%', LHP_PARAM_RESULT_VALUE) = 0
Post #1420374
 Posted Thursday, February 14, 2013 10:15 PM
 Ten Centuries Group: General Forum Members Last Login: Monday, June 6, 2016 1:51 PM Points: 1,400, Visits: 3,059
 raguyazhin (2/14/2013)PATINDEX('%[^0-9]%', LHP_PARAM_RESULT_VALUE) = 0The key, then, is the Not-to-match operator, "^". Zero returned means PATINDEX() found no characters other than digits, 0-9. Got it! Thanks for the clarification.
Post #1420379
 Posted Tuesday, May 7, 2013 12:09 PM
 SSC Eights! Group: General Forum Members Last Login: Yesterday @ 7:27 PM Points: 989, Visits: 1,930
 In your query you are casting as decimal(18,2). Are your numbers always going to be whole numbers?The following example select PATINDEX('%[^0-9]%', '1234234.20') does not return zero. ----------------------------------------------------How to post forum questions to get the best help
Post #1450286

 Permissions