Best alternatives in T-SQL are:

ISNULL ( check_expression , replacement_value ) 

OR

 LEN(check_expression) = 0

You are going to miss Foxpro big time.

Very wise.  I know many languages, but I think knowing Fox gives me a big advantage over those who don't.

I am not sure what motivates your strategy of moving into SQL and then back out, but I suspect the main problem would be in type conversions between Fox and SQL. ...

It should be very straight forward and simple to write a view as you indicate. But as mentioned, it might be easier and or more efficient to create a view in...

You are very lucky to have Foxpro at your disposal. Foxpro makes a much better front end to SQL than VB. You can use VFP to create a connection...

quote:

---

Looking for some good input here 🙂

---

You may not recognize this as good input, but...