preventing an SQL login hack

As most of you may or may not know, when you have a username and login screen, ie:

where name = 'name'
and pw = 'pw'

there is a way to make this statement always return true, allowing you to bypass/hack in.

Does MS SQL have any built in function to prevent this, or anyone have any suggestions?

There are some possibilities to make such statements allways true. Each one has prevent functions.
Which one of them do you mean?
______________________________________________

e.g. in VBasic : Replace(Username, "'", " ")

single quotes = rem --> they are very dangerous