I have a query like this:
SELECT Replace(Convert(varchar(5), ru.StartTime,8),':','') as StartTime
FROM Geography
WHERE :dateuse = ...

I set the the dateuse parameter, but it gets confused with the colon I'm using in the select cluase. Are there any escape characters I can use to escape that colon?

Not sure on the escape character, but thought I'd point out a not-very-i18n-compliant solution if you're in a hurry:
Your database will normally have a CHR or CHAR function for converting a numeric ascii value (readily retrieved using the ASC/ASCII function) to a character. I suspect NHibernate won't have a problem with that...

Mike.

Are you sure it's not your second ':' that's wrong?

Shouldn't it be:

I have a query like this:
SELECT Replace(Convert(varchar(5), ru.StartTime,8),':','') as StartTime
FROM Geography
WHERE dateuse = :paramName

Check the documentation here and look under "Tips and Tricks" at the bottom:
http://www.hibernate.org/hib_docs/nhibe ... ryhql.html

You could also try this

SELECT Replace(Convert(varchar(5), ru.StartTime,8),':','') as StartTime
FROM Geography as g
WHERE g.dateuse = :paramName

also when you replace the named parameter do it like this
.SetParameter("paramName", value)

not
.SetParameter(":paramName", value)