Replace() && Upper () In Stored Procedure

Hi;





I have a stored procedure :





<code>





Create Procedure ControlDept


(





@DeptID nvarchar(10)


)


As


If Exists


(


Select DeptName From Departments Where


DeptID LIKE @DeptID


)


Return 1


Else


Return 0





Now I want to apply replace and upper functions to DeptID in database before saying


"DeptID LIKE @DeptID".





for example the parameter is :"D&V"


DeptID in database is:"d & v" //there are spaces





if I say DeptID LIKE @DeptID nothing is found because of character nonmatching


So I have to apply replace & upper functions to the column DeptID in database





but how?


can you help me please??