1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

Trim statement?

Discussion in 'SQL - Questions and Answers' started by Mohsin, Dec 13, 2006.

  1. Mohsin Guest

    Dialect: SQL 92
    What is trim statement in sql and what does it do
    Mohsin, Dec 13, 2006
    #1

  2. Dimitar Guest

    Dialect: SQL 92
    TRIM statement? Or TRIM function?

    The TRIM function is useful for removing leading, trailing or both characters from a string.

    Example:
    SQL:

    
select trim(leading '1' from my_coumn) from my_table
    Dimitar, Jan 3, 2007
    #2

Share This Page