SQL Server 2008 LIKE Query

Question

I want to use a query LIKE

to select a specific word like UU1

.

I use

SELECT UniID FROM MasterCustomer  where (UniID like '%uu1%' )

But it also returns a string containing UU11

.

How can I change my request to select only UU1

?

My table contains values like

UU1-UU7-UU5
UU2-UU1
UU3-UU1
UU31-UU14

+3

sql-server-2008

Neha 11 Feb 13 at 17:15

source to share

3 answers

like '%uu1-%' or like '%uu1 %'

0

paul 11 Feb 13 at 17:18

source to share

Another alternative:

WHERE UnitID + '-' LIKE '%uu1-%'

0

Andriy M 11 Feb 13 at 18:44

source to share

Sebastian meine · Accepted Answer · 2013-02-11T17:18:22+0000

try this:

SELECT UniID 
FROM MasterCustomer  
WHERE (UniID like '%uu1' ) OR (UniID like '%uu1-%' )