Basicly $StateProvince in a string value in you sql statement, so you either single quote yourself, or let DBI do it.
Or use a placeholder and save yourself the pain of figuring it out:
select ... where name_short = ?
will do the deed without your having to even think about quoting.
-- Steven Lembark 85-09 90th Street Workhorse Computing Woodhaven, NY 11421 [EMAIL PROTECTED] 1 888 359 3508