[sqlite] SQLite GUID in WHERE Clause

Simple question, likely to have a simple answer. I have tables in SQLite using GUID primary key columns. I am attempting to select a row based on its literal guid value in C#.Net. Here's a sample query: SELECTRole.Id, Role.Name, Role.Description, Role.Active, Role.BitMask FROM

Re: [sqlite] SQLite GUID in WHERE Clause

I know the literal GUID value shown is correct, as I copied it directly from the results pane when I do a SELECT * FROM UserRole, however, as soon as I add the WHERE clause, I get no results. Execute 'SELECT UserId, typeof(UserId) FROM UserRole' preferably from sqlite command line utility