Remove Characters in MSSQL record

[rpeacock]

Is there a way to basically trim off the last X characters in a field?

Example

Field 1 Value - 15000
Field 2 Value - 2645678

Desired output - 15
Desired output - 2645

Can I perform a trim or something to remove the last 3 or X number of characters?

I know that I can RTRIM for spaces, but I wanted to trim the actual characters.

Thanks in advance!

[iburyak]

Try this:

[PHP]
select substring(cast( 2645678 as varchar(20)), 1, len(cast(264567 8 as varchar(20))) - 3)[/PHP]

Good Luck

[rharvieuxsql]

--Try this

select LEFT (your_column, LEN(your_column )-3) from your_table