Simple Question PLease URGENT

[firas489]

Hello All,

I'm having a little problem in witting an SQL statement.
I'm sure there is a simple solution for it but its just not clicking with me!.

Anywayz,

I'm trying to write a statement that in the FROM clause, there is a formula, and i would like to assign conditions to this formula in the WHERE Clause
Ex:

SELECT DateValue(FLD_AS_STRING) FROM Table1 WHERE ???

I want the statement to convert the FLD_AS_STRING field (which is in string format) to Date format, and in the same time i want to only view fields that it's FLD_AS_STRING is greater than today's date (after it is converted to Date)?

How can i do that in this statement?

Thanks in advance,

Best Regards
Firas S Assaad

[Sulley's Boo]

select to_date(FLD_AS_STRING, 'dd/mm/yyyy') 
from Table1
where to_date(FLD_AS_STRING, 'dd/mm/yyyy') > sysdate;