How to find exact match of a value in a table

Question

Post reply

How to find exact match of a value in a table

dakshinamurthy-655138

SSCertifiable

Points: 5172
More actions
February 26, 2009 at 3:08 am

#155334

Hi,
How to find exact match of a value in a table
means User should be replaced by Employee
if text is like this " User has primary key UserID"
it should replace only User text and not the UserID text.
The replace function wil replace both..
so i need to find the exact match
With Regards
Dakshina Murthy

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Samuel Vella SSCrazy Eights Points: 8055 More actions · Answer 1

you can match on User plus the space

replace(columnname, "User ", Employee ")

or you can change the userid part of the string first, then revert afterwards

replace(replace(replace(columnname, "UserID", "UxSxExRxIxDx"), "User", "Employee"), "UxSxExRxIxDx", "UserID")

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 2

Use the spaces before and after the word 'User', like this:

REPLACE(mycolumn, ' User ', ' Employee ')

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

See also here.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Samuel Vella SSCrazy Eights Points: 8055 More actions · Answer 4

Chris Morris (2/26/2009)
See also here.

Nice circular reference there Chris 😀

Whens your next TV show coming out?

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

Samuel Vella (2/26/2009)
Chris Morris (2/26/2009)
See also here.
Nice circular reference there Chris 😀
Whens your next TV show coming out?

Cheers! Looks a lot like homework hey?

Nah that's a different Chris Morris, there are loads of us. I don't have a sufficiently brass neck.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

dakshinamurthy-655138 SSCertifiable Points: 5172 More actions · Answer 6

Hi,

There is nothing like a home work or copied the same thing, i came across this and i have posted, may similarly the other guy might have also come across and might have done.

Any ways thanks for the help

With Regards

Dakshina Murthy