Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with query when there is bad data
Message
From
21/06/2009 15:32:39
Sergey Berezniker
New York, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Help with query when there is bad data
Environment versions
SQL Server:
SQL Server 2000
Application:
Desktop
Miscellaneous
Thread ID:
01407429
Message ID:
01407434
Views:
25
You can use idea from my other message but simply check for 
LEN(UpTime1)=5 AND LEN(DownTime1) = 5
>13: vice 13:00
>
>Just incomplete time value.
>
>Thanks
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform