Finding number of Characters in SQL '' String
Hi, I have multiple SQL files that contains descriptions for various items, now this SQL will be imported into a database, however, because the descriptions comes from a 3rd party their description character length is sometimes longer than 255 , that of the field size in the database table. Is there a way I can go search through these files finding the descriptions that is longer than what is allowed?
If there is a pattern in how they do the description, it should be possible.
Can show us an example and describe how you want it to be done?