use the substring() function.
select zip, substring(zip, 3) as f from ziptable group by f
I dont remember the exact syntax but you get the idea.
__________________
I rarely give code examples.
No, I have never used IIS or Windows of any kind as a web server. Get a real OS!
Please don't PM me, I won't respond.
|