255 character limit in Paradox alpha fields

Is there a database where the alpha fields are not limited to 255
Using paradox tables I have to store longer strings in a memo field.
This is fine except that queries then take a long time to execute when
searching on the memo field (I am searching for a substring in this
Any suggestions on alternatives to paradox or how to speed up the