Use '=' or LIKE to compare strings in SQL

SELECT count(*)
FROM master..sysobjects as A
JOIN tempdb..sysobjects as B
on A.name = B.name

SELECT count(*)
FROM master..sysobjects as A
JOIN tempdb..sysobjects as B
on A.name LIKE B.name

SELECT * FROM user WHERE login LIKE 'Test%';
-- Matches
--   TestUser1
--   TestUser2
--   TestU
--   Test
--   etc.

select * from people where name ilike 'JOHN'

select * from people where name ~ 'John.*'