>>>>And what's the back end? I ask, since no SQL server that I know of uses sql as a file extension.
>>>
>>>it what i have been given - please excuse me i will go back to my source
>>
>>Colin that is probably a file that if opened in SQL server will create and populate a table of postcodes in SQL server.
>>
>>Similar to
http://www.ukpostcodes.org/postcode-database-api-downloads uk-postcode-database.sql
>
>Ok thanks to all
.sql extension is for executable script files. You just need to open this file in SSMS and then execute it (make sure to select correct database first). It will most likely create that table.
Also, you can examine the code and most likely you will be able to run that same code in VFP with very minor modifications to create the table in VFP as well.
If it's not broken, fix it until it is.
My Blog