#DateForumTypeThreadPost
931 Aug 2015 @ 11:56 PDTGeneralTopicconvert julian 5 digit number to regular dateI have the following field with julian numbers: Date_Created 14304 14365 and so on. I used the following formula SELECT  CAST(CAST(Date_Created AS CHAR(7)) AS DATE FORMAT 'yyddd...
831 Aug 2015 @ 11:37 PDTGeneralReplyHow to create a dynamic concatenationThank you dnoeth, very much. both work very nicely. just one question, what is the '1000000' in the second method, for?
731 Aug 2015 @ 07:15 PDTGeneralReplyHow to create a dynamic concatenationOk, I used this function however, here is what I am getting:   BR_NO = 974 ACCT_NO = 242101 Results:     974  242TDA As you see, there are spaces before the BR_NO (4...
629 Aug 2015 @ 08:58 PDTGeneralReplyHow to create a dynamic concatenationSorry, here is a sample data again: Concatenate the yellow columns to look like the green column. number of leading zeros will change because the Br_No is not fixed:  
528 Aug 2015 @ 01:39 PDTGeneralTopicHow to create a dynamic concatenationI am trying to concatenate 2 fields ACCT_NO and BR_NO where both fields should add up to 12 character and if not I should add leading zeros. concatenation must have a suffix of TDA. For example: 0...
408 Jun 2015 @ 07:10 PDTDatabaseReplyConcatenate using || causes nullThank you.
305 Jun 2015 @ 08:30 PDTDatabaseTopicConcatenate using || causes nullI noticed that when I am using || to concatenate several fields, if one of them is null, the function returns null. Is there a way to return whatever values that are not null and ignor the null val...
221 Apr 2015 @ 11:10 PDTDatabaseReplyCheck for Dummy data (String comparison)Fair enough, that works fine, i also used thank you for your help
121 Apr 2015 @ 08:14 PDTDatabaseTopicCheck for Dummy data (String comparison)I have a table 'RAW_AML_ACCOUNT_JUN' which has 'ACCT_FIRST_NAME' field. I would like to check if there is any dummy data in the first name. for example: #,$,@,&,!,?,:- ...