Limiting the amount of characters returned

[kevin]

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

[kevin]

Sorry I meant ASP, SQL would be fine too though.

[Bob Barrows [MVP]]

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"

[Aaron Bertrand [SQL Server MVP]]

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