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
 SSCommitted Group: General Forum Members Last Login: Tuesday, October 22, 2013 1:39 PM Points: 1,519, Visits: 3,032
 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: Today @ 9:54 PM Points: 82, Visits: 315
 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: Today @ 9:54 PM Points: 82, Visits: 315
 PATINDEX('%[^0-9]%', LHP_PARAM_RESULT_VALUE) = 0
Post #1420374
 Posted Thursday, February 14, 2013 10:15 PM
 SSCommitted Group: General Forum Members Last Login: Tuesday, October 22, 2013 1:39 PM Points: 1,519, Visits: 3,032
 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 07, 2013 12:09 PM
 SSC Veteran Group: General Forum Members Last Login: Wednesday, August 28, 2013 1:34 AM Points: 219, Visits: 684
 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.
Post #1450286

 Permissions