Solved

tsql select field contain like MO TU WE TH

Posted on 2012-12-25

1 solution

446 Views

Last Modified: 2012-12-25

I HAVE A FIELD NAME recurencerule

DTSTART:20110903T150000Z DTEND:20110903T160000Z RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=MO;WKST=SA
DTSTART:20120505T140000Z DTEND:20120505T160000Z RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TU,WE,SA,SU;WKST=SA
DTSTART:20120907T140000Z DTEND:20120907T160000Z RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=FR;WKST=SA
DTSTART:20121129T150000Z DTEND:20121129T160000Z RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TH;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 ?

Comment

Question by:afifosh

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

1 Comment

LVL 70

Accepted Solution

by:Qlemo

Qlemo earned 500 total points

ID: 387199682012-12-25

It's not completely clear. Do you want to see if a specific weekday is in the BYDAY list? In that case:

declare @ThisDay char(2)
set @ThisDay='TU'

select * from tbl where recurencerule like '%;BYDAY=%'+@ThisDay+';WKST=%'

Open in new window

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server database migration - The Detach/Attach method

Article by: Vitor

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.

How to recover deleted rows in SQL Server

Article by: Yashwant

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.

How to scan a network for running services?

Video by: AdRem

In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…