gabor <[EMAIL PROTECTED]> writes:
> i have a table, where there is a varchar(500) column,
> which contains data that is strangely formatted:
> it starts with letters, and ends with a number.
> for example:
> xyz001
> xyz002
> xyz044
> xyz1243
> abc01
> abc993
> abc2342
> now, for a given text-pre
hi,
i have a table, where there is a varchar(500) column,
which contains data that is strangely formatted:
it starts with letters, and ends with a number.
for example:
xyz001
xyz002
xyz044
xyz1243
abc01
abc993
abc2342
and so on.
now, for a given text-prefix (for example "xyz"), i need to
find
