TRIM(BOTH '09'xc FROM col)

Database
Enthusiast

TRIM(BOTH '09'xc FROM col)

In the above sample '09'xc denotes a tab. But what are the other options that can be in that place. What is that option.

Tags (2)
2 REPLIES
Junior Contributor

Re: TRIM(BOTH '09'xc FROM col)

Sorry, i didn't answer your previous post, i just forgot it.

XC indicates a hexadecimal string literal, i used it instead of a tab character enclosed in quotes because some editors replace a tab with something else, e.g. blanks.

Within TRIM this option indicates the character to be trimmed, the default is a blank.

You'll find more details in the manuals:

SQL Functions and Operators -> TRIM

SQL Datatypes and Literals -> ''XC

Dieter

Enthusiast

Re: TRIM(BOTH '09'xc FROM col)

Thanks for the information Dieter...