January 12, 2012 at 7:34 am
Hi
Sorry for the post but I have run out of ideas where to start.
I'm have a client that has exported a file and part of this has a field length of near 2000 characters,
whilst I can increase the import field to varchar(max) to get the export into the system, it then needs to update another table that has a field length of 500, and changing this will then have implications elsewhere.
Therefore apart from telling the client to remove all characters past 500 on the data they export.
I was looking at trying to remove all the text exceeding the 500 field length.
Anyone able to help out.
January 12, 2012 at 7:38 am
Use the LEFT command keyword.
...
SET shortColumn = LEFT(longColumn,500)
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 12, 2012 at 8:34 am
Thanks very much for that it has done the trick.
January 12, 2012 at 9:28 am
I do have one question, is there data past 500 characters that the customer needs?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply