Andy, you might get some help if you posted table structure and sample data, including create and insert statements, and a sample of what you want the results to look...

Matt Miller (10/26/2007)

---

Results:

raw sort 52956

convert sort 89013

and now with an index

raw sort ...

Mike Levan (10/26/2007)

---

How can I check if a date is a valid date format, the field has date in '11/16/2004' format.

overall i need to check if the date is in...

Mike Levan (10/26/2007)

---

I have a column with Varchar(100) and it allows to enter numbers but it also allows to enter date like '1/3/1998' which ia wrong entry, I am not...

Michael Meierruth (10/26/2007)

---

Tomm Carr (10/25/2007)

---

BUT, I still want to know from all those against including the start date in AddWorkdays or Workdays where in the real world this concept comes...

Thanks Sergiy. I had no idea what was happening when you make changes in EM.

Mike Levan (10/25/2007)

---

Exactly, this will be on sheduled basis but i dont want to use a table to track my errors, as and when I run this proc before import...

Well, I can't replicate it, but I know I had an issue with it before. Maybe I'm just crazy.

Kenneth Wilhelmsson (10/26/2007)

---

You can still order by that as well..

Or are you talking about something else, Greg?

J M - the place in BOL you're looking for is under 'CONVERT'

There...

Well that answers my question then. Why do I care? I'm just like that. I want them all to be the same I guess. Thanks

Greg

If you do not need to order by the date, you can use CONVERT(CHAR(10),YourDate,101).

If you do not need to order by the date, you can use CONVERT(CHAR(10),YourDate,101).

Thanks mrpolecat. That worked, but I want the ID column to be the first column in the table. Is this...

If you are using a frontend app you could probably take care of that kind of validation on the frontend. If the values entered meet the validation criteria then...

Ok, I was not looking at the master object tree when I posted. So sysxlogins is the last table, but the name has the domain tacked on to it....