× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. February 2010

Re: AW: Using SQL to obtain a 6 character field from a 3, 4, 5 or 6 character string

Taking baby steps I modified this

Select cast(Repeat('0', 6 - Length(Trim(MyFld)))
concat Trim(MYFLD) as char(6)) as NewTxt
,A.*
FROM QTEMP/DELETEME A
....+....1....+...
NEWTXT MYFLD
000001 1
000012 12
000034 34
123456 123456
++++++ 1234567899

Then I zapped a line in front and a character at the end
Create view qtemp/deletemev as(
Select cast(Repeat('0', 6 - Length(Trim(MyFld)))
concat Trim(MYFLD) as char(6)) as NewTxt
,A.*
FROM QTEMP/DELETEME A)
View DELETEMEV created in QTEMP.

and got
select * from qtemp/deletemeV
....+....1....+...
NEWTXT MYFLD
000001 1
000012 12
000034 34
123456 123456
++++++ 1234567899




Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.