sorting received SMSes

Question

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?

or maybe there's another way to do this..?

thank you!

Answer 1

Hi peanutong,

 This forum is for software developers who are using the Open Protocol Specification documentation to assist them in developing systems, services, and applications that are interoperable with Windows.

The Open Protocol Specifications can be found at: http://msdn2.microsoft.com/en-us/library/cc203350.aspx.

Since your post does not appear to be related to the Open Protocol Specification documentation set but rather to an implementation question, I suggest you post your question on the following forum: 

SQL Server Database Engine

 (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1) as it looks more adequate for your question.

Thanks and regards,

---

SEBASTIAN CANEVARI - MSFT SEE Protocol Documentation Team