Skip to Content

I need to Convert Varchar to Integer in sap bods

Hi All,

I nee to Convert Varchar to Inetger in sap bods?

I have source is varchar datatype and Target is integer data type

I have in source column is Mastercard is 'Yes' and but target will be showing in '1'

Please let us know..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 06, 2016 at 11:24 AM

    decode(source_column = 'Yes', 1, 0)

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2016 at 12:56 PM

    Thanks Dirk

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23 at 12:56 PM

    Hi Shazin,

    Thanks for replay! I need to test stored procedure step by step. In this stored procedure they are used 20 select statements. All select statements are temp tables. I need to figure out which select statement taking lot of time. I have tested in SQL Server side but i need to test SAP BODS also.

    Thanks,

    krish.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22 at 11:59 AM

    Hi Dirk,

    I am going to ask you one question ?

    Below the Script is SQL Server Script

    IF OBJECT_ID('tempdb..#tblDebugLog') IS NOT NULL

    DROP TABLE #tblDebugLog

    How to write above the script in SAP BODS in Scripting? Can you please let me know.

    If you replay to me it is very helpful.

    Thanks,

    krish.

    Add comment
    10|10000 characters needed characters exceeded