Viewing 3 posts - 1 through 4 (of 4 total)
--===== This solution is like your request
SELECT LEFT(Jurisdiction_ID,2) AS State,
LEFT(Jurisdiction_ID,5) AS State_County,
LEFT(Jurisdiction_ID,8) AS...
October 5, 2008 at 7:05 pm
#880941
No that's why I thought I could use LEN since State = 2 Characters, State/County = 5 Characters, State/County/City = 8 Characters. I know it would need a few...
October 3, 2008 at 8:15 pm
#880781
Sorry I'm new to this and not even sure if the below statement is correct.
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#mytable','U') IS...
October 3, 2008 at 3:05 pm
#880716