Getting no result

[Dukester0122]

I have a formula which I need to add get more info.

select {TABLE01.ORDERNUMBER} [1]
case "B" : "BORD#"
case "D" : "DORD#"

I was trying this but won't work

select {SOP10100.SOPNUMBE} [2]
case "BO" : "BORD#"
case "DO" : "DORD#"
case "BP" : "BP#"
case "DP" : "DP#

 

[synapsevampire]

Try:

select left({SOP10100.SOPNUMBE},2)
case "BO" : "BORD#"
case "DO" : "DORD#"
case "BP" : "BP#"
case "DP" : "DP#"


-k

 

[rosemaryl]

Or,

Try

select {SOP10100.SOPNUMBE} [1 to 2]
case "BO" : "BORD#"
case "DO" : "DORD#"
case "BP" : "BP#"
case "DP" : "DP#"

You were actually requesting the second character from the field, not the first two.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[Dukester0122]

That worked fine. Thanks to both.