Oracle Trim

TRIM('   test   ')
Result: 'test'

TRIM(' '  FROM  '   test   ')
Result: 'test'

TRIM(LEADING '0' FROM '000123') -- Baştan
Result: '123'

TRIM(TRAILING '1' FROM 'Test1') -- Sondan
Result: 'Test'

TRIM(BOTH '1' FROM '123Test111') -- Hem Baştan Hem Sondan
Result: '23Test'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: