[SQL] Closes Match

[Christian Rusa]

Hi there,


I was asking myself if its possible to realise this in SQL.

So if the string is:
abcdefg

And in the database are entries like:
a
ab
abc

I just want to get back 'abc'.

I looked around in the internet and the documentation but found no solution.

Cheers Christian

I want to match a string against the database and get the closest (shorter) match.

smime.p7s
Description: S/MIME Cryptographic Signature