in the command field Type Varchar has the following but how to

[pectin232]

The database has all the fields as telephone nos.. like
(702)223-2222, somehow a few has email address instead of phone nos. How do I show like if it is not a phone no then show it as NA or 'Not Available'. Thanks

 

[pectin232]

Something like this in Select Expert

IF{Command.TELEPHONE} <> isNumeric then
{Command.TELEPHONE} = 'Not Available'

 

[lbass]

Try:

if isnull({table.field}) or
trim({table.field}) = "" or
instr({table.field},"@") <> 0 then
"Not Available" else
{table.field}

-LB