Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  a ' in a select statement

Author  Topic  Zubie Starting Member 5 Posts Posted - 2001-01-19 : 09:07:29 Hey all ... I have a problem with a select statement. In the where section the name I'm trying to reference includes a ' (e.g. O'Connor). when trying to execute the sql I recieve ORA-00933: SQL command not properly ended is there some way to delimit the quote? Thanks for the help Dave example if SQL Select Func_Production from mis.misuser where UserId = 'O'Connor'