LEFT(string, n) for text type ?

  • Is there any function for left(...,n) or substring() for text type ?

    If not, does anybody know any udf for this?

  • stupid me... substring is working, even for texttype...problem solved. 🙁

  • Thanks for letting us know you solved it yourself, Virgil. Don't worry about it. We've all had moments when we overlooked a simple and obvious solution.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply