I want to write query in that i want to add condition on enum field.
How to compare enum value in query ?

Kindly provide syntax as soon as possible.

I want to write query in that i want to add condition on enum field.
How to compare enum value in query ?

Kindly provide syntax as soon as possible.

Hello,

etol()
Syntax:

function long etol (domain domain_value)

Description

This returns the numeric code corresponding to a specified value in an enumerated domain.

Arguments

domain domain_value The name of the domain. The domain must be of type enumerated.


Context

This function can be used in all script types.

Regards

Example

where tablefield = tcyesno.yes