Member_2_6478753
asked on
tsql select field contain like MO TU WE TH
I HAVE A FIELD NAME recurencerule
DTSTART:20110903T150000Z DTEND:20110903T160000Z RRULE:FREQ=WEEKLY;INTERVAL =1;BYDAY=M O;WKST=SA
DTSTART:20120505T140000Z DTEND:20120505T160000Z RRULE:FREQ=WEEKLY;INTERVAL =1;BYDAY=T U,WE,SA,SU ;WKST=SA
DTSTART:20120907T140000Z DTEND:20120907T160000Z RRULE:FREQ=WEEKLY;INTERVAL =1;BYDAY=F R;WKST=SA
DTSTART:20121129T150000Z DTEND:20121129T160000Z RRULE:FREQ=WEEKLY;INTERVAL =1;BYDAY=T H;WKST=SA
i want to search for the variable like TU or WE MO FR SA SU IN THE LAST OF THIS STRING..
FROM BYDAY=TU,WE,SA,SU;
BYDAY= xx,XX,XX,XX ;
SEARCH INSIDE THIS ONLY ?
DTSTART:20110903T150000Z DTEND:20110903T160000Z RRULE:FREQ=WEEKLY;INTERVAL
DTSTART:20120505T140000Z DTEND:20120505T160000Z RRULE:FREQ=WEEKLY;INTERVAL
DTSTART:20120907T140000Z DTEND:20120907T160000Z RRULE:FREQ=WEEKLY;INTERVAL
DTSTART:20121129T150000Z DTEND:20121129T160000Z RRULE:FREQ=WEEKLY;INTERVAL
i want to search for the variable like TU or WE MO FR SA SU IN THE LAST OF THIS STRING..
FROM BYDAY=TU,WE,SA,SU;
BYDAY= xx,XX,XX,XX ;
SEARCH INSIDE THIS ONLY ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.