a.JURISDICTIONCODE as DummyField1,
to_number(REGEXP_REPLACE(REGEXP_REPLACE(b.value,’[a-zA-z]’,’’),’,’,’’)) as DummyField3
However, I keep getting erroe messages. I know the ‘#’ sign is reserved for SQL Server 2005 and such, but it’s the only coding I could find in my google search. Any help is much appreciated. Thanks!
First time POSTER. I’m trying to create a temp table with the following syntax…
CREATE TABLE #myTempTableDummyField3 FLOAT****************b.JURISDICTION_CODE=a.JURISDICTIONCODE