That is syntax (mostly) for T-SQL ISNULL() - that is not syntax for VFP ISNULL()
VFP only takes one argument for isnull() John C. Gunvaldson www.fox-net.com *== There must be a simple answer that I'm not getting. When I run this I get a "too many arguments" error. CREATE SQL VIEW RB ; AS SELECT ISNULL(lot_salenum,"") as salenum ; from currbauction currbauction *== _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
