Q&A for professional and enthusiast programmers
select ('http://stackoverflow.com/q/' + cast(id as varchar)) as url,* from posts where posttypeid = 1 and tags = '<web>'