Check CAST() function which is avaialble in VFP9 as well. Just keep in mind that SQL Server doesn't support empty dates so you'll have to use Nulls. The SPACE() function is also a T-SQl function.

>I think the reason I'm having trouble finding this in my SQL books is I don't know what to call them.
>
>In VFP I could say
>
>SELECT field1, {} as mydate, guid() as myguid, space(10) as mytextfield
>
>etc.
>
>What are the SQL equivalents whenn writing remote view code? And what do you call these 'phoney fields' in a select statement ?
>