i am using ozeki sms server to send/receive SMS. currently, when i receive SMSes, they will be inserted into this messagein table (microsoft sql server) altogether. however, i wish to implement it this way:
user A sends message to #1: hello [TO REPLY: user A <SPACE> <MESSAGE>]
#1 replies user A: user A hi
and i'll be able to sort the messages from user A, B, C etc..
how can i do that as "user A hi" is a string altogether? is it possible to create a WHERE statement from part of the string?