+John Teacake MVC Posted December 14, 2004 MVC Share Posted December 14, 2004 How could I specify that the data in a SQL schema should be in the format : ?aaa-bbb-ccc? Thanks in Advan:) :) Link to comment Share on other sites More sharing options...
0 azcodemonkey Posted December 14, 2004 Share Posted December 14, 2004 I don't think you can. You can use a stored proc or function to verify the data is in the correct format, and format it if it isn't. Ideally, you'd want to verify the format when the client enters it, before you ever hit the DB. Link to comment Share on other sites More sharing options...
0 +John Teacake MVC Posted December 14, 2004 Author MVC Share Posted December 14, 2004 As we are just using the query analyser I will just have to make a stored function/procedure. Link to comment Share on other sites More sharing options...
Question
+John Teacake MVC
How could I specify that the data in a SQL schema should be in the format :
?aaa-bbb-ccc?
Thanks in Advan:) :)
Link to comment
Share on other sites
2 answers to this question
Recommended Posts