Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Who knows how?

Updated: 22 May 2010 | 1 comment
savnhga's picture
0 0 Votes
Login to vote

I am looking for ideas on removing a leading character when scanning assets.

I need to remove the leading "S" when scanning serial numbers on monitors and sometimes computers and printers. The Asset Users need the ability to scan the Serial Number on the outside of boxes when received however they don't want the leading "S" to scan.

Any help would be much appreciated.

Comments

MFINN's picture
15
Sep
2008
0 Votes 0
Login to vote

Substring

Use the substring command to start at the 2nd character.

SELECT SUBSTRING (column_name,start,length)

Your 'start' value would be 2, since you just want to skip the first character, and, if you leave 'length' blank, it will return the rest of the characters in the string.