RE: [Programmer-VB] Sort Character value

[Nugroho Prasetyo]

Title: Message





Terima kasih Om Mawardi, ternyata bisa solve dengan 
 
> 
SELECT Brs FROM Table1 ORDER BY Int(Left(Brs,2));
Left 
dipergunakan untuk ambil karakter angka saja, mungkin bisa langsung dengan VAL 
namun 
belum 
dicoba karena buru2.
 
Regards,
 
Inu*********** REPLY SEPARATOR 
***********On 29/09/2005 at 10:04 Mawardi wrote:

  Kalau di Access memang lain pak....coba gunakan ini
   
  SELECT [Field]  FROM [Nama Table] ORDER BY Int([Field yg typenya 
  Text]);
  ex.
  SELECT Brs FROM Table1 ORDER BY Int([Brs]);
  





Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]







  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Programmer-VB" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.