Substring <>

[Steve95]

Hi All

I am new to sql, I am working from a sql 2000 view. I need to set a <> criteria on a field called account. The account field is a datatype varchar. I want to be able to create a statement which basically stops a certain certia feeding through.

I hope this makes sense, if I have missed anything please do ask.

Many Thanks

 

[ptheriault]

SELECT *
FROM MyTable
WHERE account <> 'Your Account'



If you provide us with your table structure and some more information we can give more.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Steve95]

Hi

thanks for that, think I need abit more information

I need to extract the below information from this string

CN=Lyn Jones/OU=BBC/O=Extranet

The name: Lyn Jones

Company: BBC

And the last word 'Extranet'

Please can you help

Many Thanks