Custom SQL script to convert from char to int

[former_member211376]

Hi all,

Anyone knows how we can convert char value to number in custom script of WEBI??

I am using oracle as my database.I have tried the oracle syntax for conversion it is working fine in SQL developer, but when I tried doing the same in custom script in WEBI it is giving me error:

Any help will be appreciable.

Thanks,

G.K.

[sateesh_kumar1]

Hi ,

Which function you are using ?

did you try cast() .

Thanks

[former_member211376]

Hi Sateesh,

I have tried Cast() function still getting the error.

Thanks,

G.K.

[sateesh_kumar1]

Which function you are using ?

[former_member211376]

I got the answer.. thanks

[sateesh_kumar1]

Hi ,

can you share answer

Thanks