hi all ;
i have cloumn in DB Table called [clients.active_phone]
and on my project have DDL and its items is
(--Select All--) --> value =0
(--Have Tel Active--) -->Value 1
(--NO Tel Active--) --value 2
and eache client in Table must have a tel active like (+9620000) or (NA) Not Available
now my question how to filter clients in SQL Qeury Based on DDL
my code is
SELECT clients.code, clients.client_name, User_Info.User_Name, clients.active_phone, clients.creation_date, clients.transfer_date, clients.user_id_fk
FROM clients INNER JOIN
User_Info ON clients.user_id_fk = User_Info.User_Id_PK INNER JOIN
procedures ON clients.procdure_id_fk = procedures.pro_Id_Pk
WHERE (clients.user_id_fk = @user OR @user = 0)