Rookie Prolem: Using DIGITS() function on an INTEGER value
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: SUBSTR(DIGITS(b.SIN),2,9) 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 [...]

Answer Question   |  July 7, 2008  2:23 PM
DIGITS, SQL, SQL statements