-
Hello,
Could someone help me out with this one:
I have several strings which lookk like this:
P830201001
Q450302001
L659832001
In my sql statement, I need to compare only the 7th character of this string. How do I get rid of the 6 initial ones and 3 trailing ones?
Any help would be most appreciated.
-
select substr(colname, 6,1) from table;
that should do it.
syntax is substr(column, startposition, length)
hope that helps
uday
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|