I want to select part of a field....

[mgould00]

i have a field that contains data like this:

LEVEL 2 CERAMIC TILE @ MASTER BATH
LEVEL 2 CERAMIC TILE @ OPT MASTER BATH
LEVEL 2 CERAMIC TILE @ MAIN BATH
LEVEL 2 CERAMIC TILE @ KITCHEN
LEVEL 2 CERAMIC TILE @ LAUNDRY
LEVEL 3 CERAMIC TILE @ MASTER BATH
LEVEL 3 CERAMIC TILE @ OPT MASTER BATH
LEVEL 3 CERAMIC TILE @ MAIN BATH
LEVEL 3 CERAMIC TILE @ KITCHEN
LEVEL 3 CERAMIC TILE @ LAUNDRY
etc...

i want to select all the text after the '@' only, and i want it 'disticntly'

any ideas? thanks in advance....

 

[JohnDTampaBay]

Try this:

SELECT DISTINCT SubString(
CharIndex('@', Column)
, Len(Column)
)
FROM YourTable



--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[TitleistDBA]

You could try this.

select distinct substring(fieldname, 24,?)

How big is the field? For Example if you filed is char(80) you would put 80 where the ? is. This will give you the remainder of the field. Also this will only work if it is always 24 characters to after the @ sign.

http://www.acushnetcompany.com