LIKE ....% - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

LIKE ....%

Author

Topic

JezLisle
Posting Yak Master

132 Posts

Posted - 2008-12-12 : 05:22:32

In Access I have used this below to search for an ID code that has a Letter and then a Number after it

LIKE "B[0-9]*"

In SQL if I use the same principle

LIKE 'B[0-9]%'

will it work as when testing it seems to on some occassions but not other, is ther an alternate way of doing it?

soorajtnpki
Posting Yak Master

231 Posts

Posted - 2008-12-12 : 05:39:40

hi try this,

select * from ur_table where ID like 'B[0-9]%' and len(ID)=2

OK TANXX...

JezLisle
Posting Yak Master

132 Posts

Posted - 2008-12-12 : 05:42:54

My query is an UPDATE Query like below, where would that fit in?

UPDATE PARAMED_temp SET PARAMED_temp.ContactServiceID = "ACCESS TO COMMUNITY - NURSES"
WHERE (((PARAMED_temp.StaffID) Like "b[0-9]*"
Or (PARAMED_temp.StaffID) Like "r[0-9]*")
AND ((PARAMED_temp.ReferralTeamID)="RRRE"
Or (PARAMED_temp.ReferralTeamID)="NACT"
Or (PARAMED_temp.ReferralTeamID)="B"
Or (PARAMED_temp.ReferralTeamID)="RRRE"))

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2008-12-12 : 05:58:52

quote:
Originally posted by JezLisle

My query is an UPDATE Query like below, where would that fit in?

UPDATE PARAMED_temp SET PARAMED_temp.ContactServiceID = "ACCESS TO COMMUNITY - NURSES"
WHERE (((PARAMED_temp.StaffID) Like "b[0-9]*"
Or (PARAMED_temp.StaffID) Like "r[0-9]*")
AND ((PARAMED_temp.ReferralTeamID)="RRRE"
Or (PARAMED_temp.ReferralTeamID)="NACT"
Or (PARAMED_temp.ReferralTeamID)="B"
Or (PARAMED_temp.ReferralTeamID)="RRRE"))

UPDATE PARAMED_temp SET PARAMED_temp.ContactServiceID = "ACCESS TO COMMUNITY - NURSES"
WHERE (((PARAMED_temp.StaffID) Like "b[0-9]%"
Or (PARAMED_temp.StaffID) Like "r[0-9]%")
AND ((PARAMED_temp.ReferralTeamID)="RRRE"
Or (PARAMED_temp.ReferralTeamID)="NACT"
Or (PARAMED_temp.ReferralTeamID)="B"
Or (PARAMED_temp.ReferralTeamID)="RRRE"))

Try this once

soorajtnpki
Posting Yak Master

231 Posts

Posted - 2008-12-12 : 06:03:38

hi bklr
PARAMED_temp.StaffID must be of length 2 is his requirement.
i think u have to add this too..

Jai Krishna
Constraint Violating Yak Guru

333 Posts

Posted - 2008-12-12 : 06:09:37

Try this

UPDATE PARAMED_temp SET PARAMED_temp.ContactServiceID = "ACCESS TO COMMUNITY - NURSES"
WHERE (((PARAMED_temp.StaffID) Like "b[0-9]"
Or (PARAMED_temp.StaffID) Like "r[0-9]")
AND ((PARAMED_temp.ReferralTeamID)="RRRE"
Or (PARAMED_temp.ReferralTeamID)="NACT"
Or (PARAMED_temp.ReferralTeamID)="B"
Or (PARAMED_temp.ReferralTeamID)="RRRE"))

Jai Krishna

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources