in vfp I can do a simple select statement such as select * from address where zipcode="R" and I will get all zip codes starting with "R" how do I do this in sql?
TIA
Stuart