Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

Solved

tsql select field contain like MO TU WE TH

Posted on 2012-12-25

1 solution

Medium Priority

447 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 71

Accepted Solution

by:Qlemo

Qlemo earned 2000 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

Share One TLS Certificate for Remote Desktop Services and SQL Server

Article by: Brian

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.

Export Table Data in SQL Server Management Studio

Article by: Dirk

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.

Some Basic Differences Between MySQL and MongoDB

Video by: Percona

In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

[Webinar] Multi-Vector Protection from Cyber attacks

Video by: Experts Exchange

We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…