Hi Teodor, your pad idea works fine and I am very grateful for your magnificent help. However I do feel uncomfortable needing to use this “patch” as I have at present no idea where else the issue will emerge and with multiple tables and views involved in the whole project this could get very messy. As you know I have already spent many hours/days grappling with just this one issue in the login.
I will be going into serious discussion with my client to see if it is possible to fix this issue at database level.
As for the password encryption, I totally agree with Hyberbytes observations and I am aware of this issue but at present as the developer I don’t have a way to fix it.