SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
User Name
Remember Me?
Password
Register
FAQ
Search
Today's Posts
Mark Forums Read
SQL - Questions and Answers
Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.
SQL Recipes a FREE cookbook of SQL queries and examples
>
SQL queries and examples
>
SQL - Questions and Answers
Trim statement?
LinkBack
Thread Tools
Search this Thread
Rate Thread
#
1
(
permalink
)
12-13-2006, 09:44 AM
Mohsin
Posts: n/a
SQL 92
dialect question:
Trim statement?
What is trim statement in sql and what does it do
Mohsin
ANSWER(S):
#
2
(
permalink
)
01-03-2007, 04:38 AM
Dimitar
Posts: n/a
SQL 92
answer.
Re: Trim statement?
TRIM statement? Or TRIM function?
The TRIM function is useful for removing leading, trailing or both characters from a string.
Example:
SELECT
trim
(
LEADING
'1'
FROM
my_coumn
)
FROM
my_table
Dimitar
«
want to see all the queries for sql?
|
How to union two tables, and make one "override" the other for similar records?
»
vBulletin Message
Cancel Changes
Thread Tools
Search this Thread
Show Printable Version
Email this Page
Search this Thread
:
Advanced Search
Rate This Thread
Rate This Thread
:
5 : Excellent
4 : Good
3 : Average
2 : Bad
1 : Terrible
Posting Rules
You
may
post new threads
You
may
post replies
You
may not
post attachments
You
may
edit your posts
vB code
is
On
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Trackbacks
are
On
Pingbacks
are
On
Refbacks
are
On
Moderation Tools
:
Delete Thread
All times are GMT. The time now is
09:26 AM
.
Contact Us
-
SQL Recipes
-
Archive
-
Top
Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by
vBSEO
3.0.0
Copyright (c) 2006-2007 SQL Recipes
LinkBack
LinkBack URL
About LinkBacks
Bookmark & Share
Digg this Thread!
Add Thread to del.icio.us
Bookmark in Technorati
Furl this Thread!
1
2
3
4
5
6
7
SQL 92 dialect question:
