Truncating filed from 30 or more to 30 less 2

[Jimmy24]

Dear Sir or Madam,

I have a field called name that the length is 30, I have some names that a very long over 40. I need to truncate those names that has more than 30 caracters to make them 30. Would you please assist.

Thank you in advance

James

 

[gmmastros]

Use the LEFT function.

Ex:

[tt][blue]
Select Left(Name, 30) As NewName
From Table
[/blue][/tt]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ptheriault]

Could you post some sample data. What do you want the names to look like after the update?

For exmple:

If the name is like this
Paul Frances Theriault jr

Do you want

P. F. Theriault

or just the first 30 characters?

- Paul
- If at first you don't succeed, find out if the loser gets anything.