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

java - Intellij Synchronizing output directories .. -

-
i trying build project, run in debug mode , keep getting "synchronizing output directories" in intellij. takes around 5-10 minutes actual build. project empty , stored on local drive. tried invalidate catche has not worked. out of ideas .. had similar issues? most likely, of data on network drive or in profile being synchronized network drive. if on windows, try moving .ideaxxx/system directory , work directory somewhere else on c: drive.
Read more

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