On 25/01/2022 13:55, Shaozhong SHI wrote:
> I tried the following:
>
> select form from mytable where form ~
>
'^Canal$|^Drain$|^Foreshore$|^inlandRiver$|^Lake$|^lockOrFlightOfLocks$|^Marsh$|^Researvoir$|^Sea$|^tidalRiver$|^Transfer$'
>
> I used ^ and $ to ensure checking of allowed values.
>
> However, 'Backyard' was selected.
>
> Why is that?
Sounds like a candidate for a foreign key relationship.
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie