0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

select p.id as [Post Link], coalesce(u.displayname, p.ownerdisplayname) [user name], u.id as [User Link]
from posts p
left outer join users u on u.id = p.owneruserid
where coalesce(u.displayname, p.ownerdisplayname) like '%##username##%' collate sql_latin1_general_cp1_ci_ai

fork query

created mar 25 anonymous