Limit the length of a database field

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

LoudClear SSC Eights! Points: 999 More actions · Answer 1

SELECT

LEFT(Employee_Name , 12) as 'Employee First 12'

fromtbl_Employees

ZZartin SSC-Dedicated Points: 30920 More actions · Answer 2

Do you want to limit the actual number of characters in the database or just the number of characters that get displayed?

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 3

That's really best done on the client, but the LEFT string function will work.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt