Advanced Sql Query

BleepingComputer.com: Advanced Sql Query

Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Advanced Sql Query Looking to truncate one field into another.

#1 Aldark

New Member

Group: Members
Posts: 7
Joined: 31-August 07

Posted 12 September 2007 - 01:03 AM

I have a requirement to pull information straight from oen field in a table with all the data, then another that is to just select the last 3-digits of the same field and put it in a different output column.

For example if my fieldX contained AXX001-234, the other field needs to report just the 234.

Any way to do that with a SQL query?

/using MSSQL Server 2000