>>Hi. How would you say in a sql command
>>
>>
>>IF there is not a matching value in the table, use '00000'
>>
>>
>>Thanks, Randy
>
>
>SELECT ISNULL(FieldName, '00000') AS MyFieldName
>(removed rest of SQL)
>
Depends on your back-end.
In VFP you would use NVL() function.
In SQL Server you would use ISNULL() or COALESCE().
I don't know what would you use in Oracle or MySQL.
If it's not broken, fix it until it is.
My Blog