Unique Identifier

[EscapeUK]

How do I create a select statement where a pass a string looking for a unique identifier.

at the moment i try this....

select * from MyTable where documentid = 'FB6EE5A7-FO3B-11D4-BDD3-00508B8BCA16'

but get this

Syntax error converting from a character string to uniqueidentifier.

 

[Cagliostro]

try following
-----------------------------------------
select* from yourtable where documentid
CAST('FB6EE5A7-FO3B-11D4-BDD3-00508B8BCA16' AS GUID)
-----------------------------------------