Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

String Length

harongiharongi Member Posts: 3
Hi,
How can i calculate the length of a string of varchar in a field.
Example : Length of 'for' = 3, Length if 'my' = 2.

Comments

  • infidelinfidel Member Posts: 2,900
    : Hi,
    : How can i calculate the length of a string of varchar in a field.
    : Example : Length of 'for' = 3, Length if 'my' = 2.

    Use the length() function.

    v_len := length('for');

    select length('for') from dual;


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

Sign In or Register to comment.