How do you cut/trim a word using SQL and/or Access?

[keys]

I need to cut a number down that contains letters.
For example
K=GH5678+
K=CV234+

I just need 5678 and 234.

thanks

[OBonio]

Can you guaruntee that there will always be 4 characters to be ignored at the start and to always ignore the last character?

[Hapus]

select translate ( 'K=GH5678+', translate ( 'K=GH5678+', '1234567890', ' ' ), ' ' ) from
dual;
(Well in sqlplus that is - never used the others.)

[stevie21]

Are you reading this database from the web? If so then you can use asp or asp.net.

With that you can loop through the "string" one character at a time and if it passes the "IsNumeric()" test then you keep it. If not, you skip it.

[keys]

thanks

I can guarantee there will be a letter=letterletternumbernumbernumbernumber+

or

letter=letterletternumbernumbernumbernumbernumber+

I have tried Trim, Left and Right. No luck so far.

No Im not using Web just Access and SQL inside that.

[stevie21]

SELECT Left(Mid(ColumnName,5),(len(Mid(ColumnName,5))-1)) from tableName


obviously here, ColumnName is the heading of the data such as "CarNumberPlate" and tableName is, well that requires no figuring out.

Does that work? You can also bung in
AS "new table heading name"
just before "from tableName".