Up to now most of my SQL querying has been your basic:
select field from table where field = 'something'
I'm now in the position where i actually need to start doing conditional and math type scripts.
I've looked at scripts in the forums and on the web past few hours and I think i'm too deep to see the land.
Can anyone give an example script for something like the following:
i hope that makes sense. If i were writing a winform application, I could do this in code fairly fast.
Any assitance is greatly appreciated.
"The only desert to an Irishman is an empty glass".
select field from table where field = 'something'
I'm now in the position where i actually need to start doing conditional and math type scripts.
I've looked at scripts in the forums and on the web past few hours and I think i'm too deep to see the land.
Can anyone give an example script for something like the following:
Code:
get 80% of field1 as Condition1
get difference of field2 and field3 as Condition2
if Condition2 > than Condition1, return field4 and field5
Any assitance is greatly appreciated.
"The only desert to an Irishman is an empty glass".