New topic: A Question about the LIKE statement
<http://forums.realsoftware.com/viewtopic.php?t=47516> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message BrianOBrien Post subject: A Question about the LIKE statementPosted: Fri Apr 05, 2013 12:10 pm Joined: Wed Jul 07, 2010 2:55 pm Posts: 667 Location: University Of Calgary, Faculty Of Medicine I have a database column where the contents are like XX-##-###### or they are not. Where XX is two characters, dash is a dash and # is a number from 0 to 9. How do I make a select statement that can select these? select * from table where col like '??-??-??????'; _________________ If at first you don't succeed... Try REALBasic. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
