strQuery = "from TempData where englishLex=:englishLex and category =:category and language=:language and login=:login and domain=:domain group by (concat(englishlex,category)) ";


how to run this hibernate query in sql server concat function is not in sql server ?