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?

  • Hello Johan-Havenga,
    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?


Log in to reply