How to convert char to number in BO XI r3 Designer

system · July 1, 2009, 10:03am

Hi,
Could please tell me which function should be used to convert char to number in designer BO XI r3 version. I can’t see any function available for this in designer.

Manju.Shanmuagvel (BOB member since 2009-04-24)

system · July 1, 2009, 10:06am

What db are you using?

Jansi (BOB member since 2008-05-12)

MarkP · July 1, 2009, 10:18am

As Jansi hints at, this is done at the database level within the generated SQL.

You can use ToNumber at report level but would use To_Number for Oracle, cast or convert in SQL Server for example.

system · July 1, 2009, 1:10pm

I’m using SQL Server 2005, but the problem is resolved. Just with a guess I used abs() function and it worked.

Thanks

Manju.Shanmuagvel (BOB member since 2009-04-24)

system · July 1, 2009, 2:43pm

Does your data source include negative values?

Joe Szabo (BOB member since 2002-08-19)