sql - MySQL - JOIN based on CONVERT a column to NUMERIC -

-

basically, i'm trying convert table field while doing join. numbers in field starts 0009897896, 000239472938, 00032423, , forth.

i want join based convert, when query column, display numbers without leading 0s, display 9897896, 239472938, 32423 , forth.

can me avchieve this? i've been stuck on issue awhile :(

here's i've got far... joining different database:

select l.loannumber '1 loan number',        fl.loan_num '2 loan number',        case            when loannumber<>fl.loan_num "yes"            else "no"        end "issue?" loan l left join cware_cms.file_lst fl on (convert(substring_index(l.loannumber, '-', -1), unsigned integer)) = (convert(substring_index(fl.loan_num, '-', -1),unsigned integer)) left join cware_cms.case_lst cl on cl.case_id =   (select max(cware_cms.file_case.case_id)) cware_cms.file_case inner join cware_cms.case_lst on cware_cms.file_case.case_id = cware_cms.case_lst.case_id

i think want trim leading zeros. trick:

left join cware_cms.file_lst fl on trim(leading '0' l.loannumber) = trim(leading '0' fl.loan_num)

Comments

Post a Comment

Popular posts from this blog

git - Initial Commit: "fatal: could not create leading directories of ..." -

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original ...
Read more

multithreading - OPAL (Open Phone Abstraction Library) Transport not terminated when reattaching thread? -

-
i in process of writing application using opal makes h323 calls. have looked online number of working examples , have managed put resembles should like, @ present able call external ip via application when accept call craps out , dies. leaving me with: 0:12.949 setupcall:8752 sert.cxx(259) assertion fail: transport not terminated when reattaching thread , file d:\voip\software\opal\src\opal\transports.cxx, line 1021 passertfunc(0xde3f88, 0xffffffffd228226f, 0, 0) + 0x82 passertfunc(0x10d6e5f8, 0x3fd, 0, 0x10d6eb98) + 0x15b opaltransport::attachthread(0xde5870, 0xffffffffd22fc76b, 0, 0) + 0x96 h323connection::setupconnection(0xffffffffd22fc713, 0, 0, 0xde6ea8) + 0x196 asynchcallsetup(0x10d3572c, 0, 0, 0xdd0108) + 0x7c pthread1arg<psafeptr<opalconnection,psafeptrbase> >::main(0xffffffffd2282faf from have deduced, perhaps incorrectly if there thread lock issue caused (possibly arising fact application sending expected h323 call, throwing in c...
Read more