filter the data with 2 at the back

[hengsin]

table: sales
field: manufacturing code

Data inside manufacturing code:
IM2, IM, SIS, SIS2, PASSO2, APC2, SeeFei2, SeeFei

I want use the SQL to display the data with 2 at the back only. I know there is a stupid to do that, i.e.

....where ManufacturingCode= "IM2" or ManufacturingCode="Passo2" or ManufacturingCode="SeeFei2" .....

Maybe there is a better way on how to do it. Any suggesstion?

 

[Steve101]

Use:

.... WHERE ManufacturingCode LIKE '*2'

This 'wildcard *' used in conjuntion with the LIKE operator means 'match any string of characters, followed by a 2 at the end of the string.

Hope this does it


Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[onpnt]

try the like operator

eg:
SELECT *
FROM sales
WHERE ManufacturingCode
LIKE '*[2]';

the % wildcard on the beginning of the charctrer to search it will select all values that have 2 at end and no more characters after that



_____________________________________________________________________

[sub]
The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page[/sub]

 

[onpnt]

to slow and had T in mind when I explained it with the %

_____________________________________________________________________

[sub]
The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page[/sub]