Re: SQL question: check constraints on strings

jleffler@informix.com (Jonathan Leffler) on 06/02/98 04:35:03 PM To: informix-list@iiug.org, uday@rfp.rnb.com cc: (bcc: Jack Parker/Boston50/Epsilon) Subject: Re: SQL question: check constraints on strings >Uday Shankar <uday@rfp.rnb.com> asked: >>I have a question that I can't seem to find an answer to in the >>IIUG FAQ or the Informix documentation. >> >>I have a column (char strings) in which I want a check such that if a >>string I attempt to insert into >>that column starts with the substring STK, then I want the string to be >>of the format: >> >>STK.---.--- >> >>Else, it doesn't have to follow any particular format. >> >>Is there a way to achieve this ? I looked at the check constraints but >>that doesn't seem to help. > >Well, you don't indicate what the dashes or dots represent, so I'm going to >assume that dots represent dots, and dashes represent a digit. > No, no, no Jonathan - he's obviously trying to use IUS with the new Morse Code Datablade. cheers j.