[Info-ingres] add leading zero in sql

[nikosv]

  1> select * from orditems



┌──────────┬──────┐
│order_numb│item_n│
├──────────┼──────┤
│123456    │22    │
│123456    │2     │
└──────────┴──────┘
(2 rows)
  2> select
     case length(item_number)  when 1 then
      order_number+'0'+item_number
     else
      order_number+item_number
     end orderwithitem
     from orditems
	 

┌─────────────┐
│orderwithitem│
├─────────────┤
│12345622     │
│12345602     │
└─────────────┘
(2 rows)
End of Request