Return default value Progress SQL

[Anderson Apdo de Souza]

How do I return a default value when my query finds no value in the database?

 

[Rob Fitzpatrick]

"Default value" of what?

Also, if this question is specific to OE SQL then it would be better to post in the SQL-92 forum rather than the ABL-focused Development forum.

 

[TomBascom]

A code sample would go a long ways towards helping to understand what the problem is.

 

[luckboter]

Good afternoon everyone.

I imagine our friend's question is as follows:
If I do a search in a table in the database and if I don't find any results have a value set so you know that this query did not find any results, at least that's what I understood.