I'm using windows login to find the department a user belongs to but based on how the windows login is domain\_name\first\_name.last\_name; the stored procedure is not pulling the data correctly. The domain part is not stored in the employee database.

Stored Procedure

```
@name varchar
     select department from employee where  where  lower(emp_firstname) + '.' + lower(emp_lastname)=@name

```

Was trying to put the domain name in '' but that didn't work