«

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

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

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"

Answered by several people in sqlserver.programming. Please don't
multi-post.




<> wrote in message
news: 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
>