SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ismatch
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shemayb
Posting Yak Master

Philippines
159 Posts

Posted - 08/29/2007 :  03:16:47  Show Profile  Send shemayb a Yahoo! Message  Reply with Quote
in c# there is an ismatch function,is there an equivalent for that in sql server?

Funnyfrog

SwePeso
Patron Saint of Lost Yaks

Sweden
30117 Posts

Posted - 08/29/2007 :  03:20:34  Show Profile  Visit SwePeso's Homepage  Reply with Quote
LIKE

You haven't found your best friend yet, the famous BOOKS ONLINE?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

shemayb
Posting Yak Master

Philippines
159 Posts

Posted - 08/29/2007 :  03:25:18  Show Profile  Send shemayb a Yahoo! Message  Reply with Quote
example the ssn number i would like to get the correct format of it..for example if ssn ismatch(ssn)..(the format of the value,not the value itself)

Funnyfrog
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30117 Posts

Posted - 08/29/2007 :  03:38:00  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Read Books Online for pattern matching and LIKE operator.


E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 08/29/2007 03:38:18
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 08/29/2007 :  06:18:11  Show Profile  Reply with Quote
Or you could use the SEARCH function on this forum to look for "Social Security Number" ...
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30117 Posts

Posted - 08/29/2007 :  06:44:56  Show Profile  Visit SwePeso's Homepage  Reply with Quote
What is "correct format"?
Is there some knid of built-in checksum in SSN, like the LUHN algorithm?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000