Is there something like $"UEF" 1

[muppy111]

CR11
Wonder if there is something like formula":


if xxxContinent $ "UEF" then ...
else
"Africa"

meaning or U or E or F

United States,Eurpe,FarEast.
William

 

[Turkbear]

Hi,
There is this:

If xxxContinent IN ("U",'E","F")
Then
......
Else
"Africa"

OR, If you want to check each letter and act on it then try:

Select {xxxContinent}
   Case "U" :
    "United States"
   Case "E" :
      "Europe"
   Case "F" :
      "FarEast"
   Default :
      "Africa"

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[muppy111]

Thanks, the first option was the easiest but it should
be [ and not (

Thnaks anyway!
William

 

[Turkbear]

Hi,
Thats what comes from working different systems, In Oracle it is the ( while in CR it is the [

Glad it helped...






To Paraphrase:"The Help you get is proportional to the Help you give.."