sub string data

[chrisleon]

I hope I explain this well enough to get an answer.

I have a master item file.

In this item file there are item numbers ranging from 111111 to 999999.

In this item file, the item numbers with the characters 89#### are proprietary. I wish to perform an SQL query that select all item numbers except ones starting with 89.

I do not know how to do a sub string in sql.

If someone has any ideas, I would really appreciate it.

thanx

[thorpe]

Just a guess...

SELECT * FROM table WHERE SUBSTRING(field,1,2) <> '89';

[chrisleon]

unfortunately that did not work, but you gave me some good ideas of where to look.

thanx

[chrisleon]

I lied,

I was using the wrong positions in my substring. I forgot that initially all of our item numbers begin with 00, and therefore the 89 would be in the number 3 position and I would need to move 2 over.

Thanx for your help, and I apologize for the misunderstanding