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"