Avatar of AFIF JABBADO
AFIF JABBADO
Flag for United States of America asked on

sql trigger unscribption problem string manipulation

i have a messsage sent from a mobile user ..
when he send to me a msg  "u 1" unsubscribe service 1 to user...
and u 2 unsubscribe service 2 to user after

                        IF @message IN ('unsubscribe', 'u')
                        BEGIN                              
                              -- Deactivate all accounts
                              -- The user account is active, deactivate it
                              UPDATE subscriptions SET subscriptions.active = 0  WHERE msisdn = @msisdn

END

the @ message maybe it's : "how are you"  and "u" is on message ?
so what is the solution ?? i use regular expression..

so how i can solve it because i have many services and each one is related to numbers
so ???

if message is "u X" where x is a service code number
Microsoft SQL Server

Avatar of undefined
Last Comment
AFIF JABBADO

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Member_2_861731

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
AFIF JABBADO

ASKER
sorry how i can get the numbers after letter U --

??? from the messages
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23