Home » Forums » Symantec Products and Technologies » Asset & CMDB

Who knows how?

Who knows how?
savnhga's picture
Submitted by savnhga on 2 September, 2008 - 09:37.

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.

Substring

MFINN's picture
Submitted by MFINN on 15 September, 2008 - 07:34.

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.