Folk, here's my problem: My SQL knowledge is weak, but I know the basics based on RDBMS work.
I have an SQL statement that contains the following statement:
My output looks like this:
".&114172661" (Quotes added for clarity. The SIN is a 9 digit INTEGER (114172661). It's the first two 'characters' (".&") that have me stumped.
I'm thinking of replacing the SUBSTR(DIGITS(b.SIN),2,9) with CHAR(b.SIN,2,9).
Would that be correct? Any suggestions on how to fix this?
June 23, 2008 2:23 PM
July 7, 2008 4:55 PM