> I would like to know how to create a MEMO data type using SQL Syntax?
>
> Also, could you show me an example? Thanks

SELECT SPACE(256) AS Memo

Any string bigger than 254 bites becomes MEMO in VFP

and if you use latest VFP OLEDB you could use:

SELECT CAST("" AS M)

-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.