Member Avatar for peanutong

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?

thank you!

  • 2 Contributors
  • 1 Reply
  • 69 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Salem
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.