MySQL Forums
Forum List  »  Newbie

Finding a way to omit certain letters.
Posted by: Roger Novelo
Date: January 21, 2008 12:08PM

Hello,

I am new to the forum and I would like assistance with a problem I have.

I have a table with a field called CELL under this field I have rows with the following.

1X3V
1Y3V
1Z3V
.
.
.
.
.
up to
.
.
.
30X3V
30Y3V
30Z3v

I would like to find a function to omit the (X,Y,Z)3V and only output 1 - 30.

Can this be done?

Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Finding a way to omit certain letters.
January 21, 2008 12:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.