Extract Values

Hello Ramco,

As Rajeesh said you can do from SQL query or in crystal report for substring you can use Mid function,

Mid({YourStringField}, 3, 3)

You can use SUBSTRING(your_column, start_position, length) is used to extract a substring from your_column.

SELECT 
    SUBSTRING(your_column, 7 - 3, 3) AS left_chars,  -- 3 characters to the left
    SUBSTRING(your_column, 7 + 1, 3) AS right_chars  -- 3 characters to the right
FROM 
    your_table_name;

Hi Jignesh

  I want to extract from 3 position to next 3.

Thanks

You can use Left function to achieve that,

Left({YourStringField}, 3)