Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
firas489
Starting Member
2 Posts |
 Posted - 2008-05-06 : 10:00:30
|
| 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 ClauseEx: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 RegardsFiras S AssaadFiras S Assaad |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Simple Q Please URGENT!!