469,607 Members | 2,193 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,607 developers. It's quick & easy.

Limiting the amount of characters returned

Hi,

I am looking to return the first 50 characters from a database field.
Does anyone know if there is a SQL function that returns a defined
amount of characters from a database field?

Thanks in advance,
Kevin
www.seoptimise.com

Sep 18 '06 #1
3 1900
Sorry I meant ASP, SQL would be fine too though.

Sep 18 '06 #2
ke***@kevingibbons.co.uk wrote:
Hi,

I am looking to return the first 50 characters from a database field.
Does anyone know if there is a SQL function that returns a defined
amount of characters from a database field?
Of course there is. However, we cannot get specific without knowing what
database you are using: Access? MS SQL Server? Oracle? Something else?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Sep 18 '06 #3
Answered by several people in sqlserver.programming. Please don't
multi-post.


<ke***@kevingibbons.co.ukwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
Hi,

I am looking to return the first 50 characters from a database field.
Does anyone know if there is a SQL function that returns a defined
amount of characters from a database field?

Thanks in advance,
Kevin
www.seoptimise.com

Sep 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Otto Krüse | last post: by
2 posts views Thread by Jo Davis | last post: by
3 posts views Thread by Sonnich | last post: by
3 posts views Thread by DBQueen | last post: by
2 posts views Thread by prakashwadhwani | last post: by
2 posts views Thread by =?Utf-8?B?TE1X?= | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.