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?

    Cheers
    Claudia


Log in to reply