Text Messaging Program

Hello There,
I would like to ask some idea of how to do this Text Messaging Program.

Sample:
A user send a text message to our sms server(mssql) following this text format.

ex:LOAN <code>/<name>/<age>

how will i validate the user message that he/she following our text format? using mssql script.

any idea?..thanks in advance..

glen

One way would be to use Like, eg:

Code:

---

WHERE FieldName Like '% %/%/[1-9][0-9]'

---