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 : 09:58:19
|
| 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 Assaad |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-06 : 10:01:24
|
What's the emergency?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-05-06 : 10:14:11
|
| DateValue does not seem to be SQL Server function. Are you using SQL Server?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
Simple Question Please URGENT