Replace:

T_OrderHeader.CONVERT(varchar(11), OrderDate, 106),

With:

CONVERT(varchar(11), T_OrderHeader.OrderDate, 106),

See also another link http://www.dak-tek.dakotta.com/Country_City_State_List.htm to buy from.

Not all countries use the concept of 'State'. If you are trying to capture an address then you may also need to allow...

How many records would you expect to be returned?

GUI design suggests that a Listbox would not have a very large number of records so should be very fast to populate.

Try...

I am not aware of any tool that could convert the stored procs.

Looking through Google there are some that can convert tables, etc.

Stored procs only appeared fairly recently in MySQL...