• Where do you need that? In a function? In a SELECT statement?

    Please clarify

    Start here:

    SELECT 1024000 / 100000.0 AS lakhs

    -- Gianluca Sartori