Query building MSSQL (2 tasks)

Hello,

Task #1
I have 1 webpage (classic ASP) with a search field (in 1 form).
I have also other filters to make in the same page (3 forms)

My target is to build the Query that the filters have effect on the same page.

I use 1 Table

Task 2

This table contains a text-field where the user can put a 8 digit number (########).
Bij printing I set for better readable "####&nbsp,####"
On update I get this same value in my column (####&nbsp,####) with the   !
My target is by update that the   always remove.

I do not permit a connection with the MMSQL database.

Thanks in advance.

Herman.