SQL > SQL????? > Trim

SQL ?? TRIM??? ???? ???? ???? ??? ??? ???? ??? ???. ?? ?? ?? ?? ??? ???? ??? ??? ????????.??? ???????? ? ??? ??? ?????.

  • MySQL: TRIM( ), RTRIM( ), LTRIM( )
  • Oracle: RTRIM( ), LTRIM( )
  • SQL Server: RTRIM( ), LTRIM( )

?? trim ??? ??:

TRIM ( [ [??] [????? ??????] FROM ] ??????): [??] ? ???? LEADING (??), TRAILING (?), or BOTH (????). ? ???[????? ??????] ? ??????? ???? ???,?? ??? ?? ?????.?? ??? [????? ???? ??] ? ???? ???? ???? ????? ????????.

LTRIM (??????): ?? ???? ?? ?? ??? ??.

RTRIM (??????): ?? ???? ?? ? ??? ??.

? 1

SELECT TRIM ('   Sample   ');

??:

'Sample'

? 2

SELECT LTRIM ('   Sample   ');

??:

'Sample   '

? 3

SELECT RTRIM ('   Sample   ');

??:

'   Sample'

SQL CREATE TABLE >>
?


Copyright © 2021   1keydata.com   All Rights Reserved