Limit size of URL (string)

[ryanschefke]

Hello,

Is there a way to limit the size of a string returned from a select statement? For example, it is a long URL but I only want to display the first 50 characters. The way I am using the select statement in a particular section of code doesn't allow for any post processing so I need to format the string inside the select statement.

Thank you,
Ryan

[NogDog]

Most (all?) DBMS's will support something like MySQL's SUBSTRING() function.