t: Re: WoW!!!! SQL is something!
> I had a problem that required a proper sort of the following:
>
> IT66
> ITD38
.
.
.
.
> ITD100
> ITD101
> ITD102
> ITD103
> ITD104
> ITD105
>
>
> Because of the different lengths, this was a nightmare for "order by"
Thanks - this is even better - I will give it a try.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 6:19 AM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: RE: WoW SQL is something!
select req_number,
right(concat('00&
EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 5:08 PM
To: Mysql_List (E-mail)
Subject: FW: WoW SQL is something!
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD
RPAD('hi',5,'?');
-> 'hi???'
> -Original Message-
> From: Norris, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: December 04, 2002 18:26
> To: Mysql_List (E-mail)
> Subject: WoW SQL is something!
>
>
> I had a problem tha
LPAD('hi',4,'??');
-> '??hi'
> -Original Message-
> From: Norris, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: December 04, 2002 18:26
> To: Mysql_List (E-mail)
> Subject: WoW SQL is something!
>
>
> I had a problem tha
> I had a problem that required a proper sort of the following:
>
> IT66
> ITD38
.
.
.
.
> ITD100
> ITD101
> ITD102
> ITD103
> ITD104
> ITD105
>
>
> Because of the different lengths, this was a nightmare for "order by" and so
> it led me to my first experiments with case
> and I go the followin
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
IT
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
ITD1
