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 |
AFK
Starting Member
26 Posts |
Posted - 2005-02-04 : 11:57:12
|
Test |
|
bmains
Starting Member
27 Posts |
Posted - 2005-02-04 : 12:41:42
|
Wouldn't you want a case statement for requiredshiptime in the case that it is a character date (expd in your example)? That won't convert correctly to a smalldatetime. Or are you doing that in advance of this?Brian |
|
|
bmains
Starting Member
27 Posts |
Posted - 2005-02-04 : 15:14:20
|
Well the problem is EXPD will always throw off a smalldatetime conversion. Do you have a select list of these other expressions? Can you make the data more standard on the types of other expressions allowable? I don't think there is a time checker function that checks to see if the time is a valid time, but you could create your own function; if a valid time, return the time, otherwise, return null or an empty string, or zero.Brian |
|
|
|
|
|