Link to home
Start Free TrialLog in
Avatar of zachvaldez
zachvaldezFlag for United States of America

asked on

Removing last 3 right chars

How to remove the last 3 right chars from data?
SOLUTION
Avatar of Paul MacDonald
Paul MacDonald
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Which DBMS (SQL Server, MySQL, ...)?

What should the result be if the value is less than 3 chars or null?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
For anyone wondering what technology(s) a question pertains to, they can be found listed at the top between the question title and the author's original input.  In this case, the technologies given were:

Query Syntax, SQL, Microsoft SQL Server

So my guess would be "SQL Server"....
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Only query syntax is visible to me, the others don't show unless click the edit topics icon.
ahhhh.  Yea, that would have made it a little more difficult............
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

FYI

>>Yes, original tags did not contain SQL Server

Correct.

>>they can be found listed at the top between the question title

I added SQL Server based on zachvaldez's previous questions.