As 2011 comes to a close, we would like to send out a special thank you to all of you reading this.  We value and appreciate each and every one of you!  

Please accept our heartfelt wishes for a happy, healthy and prosperous New Year! 

We are starting a new section for SQL Server tips. We still plan to have Crystal Reports tips as they come up, but we thought this would be useful to our readers.

Recently we needed to work with customer ID's and names in Dynamics GP and needed to know the proper syntax to search for single quotes within a string.  For example, if you wanted to find all customer names starting with O'Brien, how would you do this in SQL?  

The answer is to use two single quotes in place of the single quote in your string.  So for the example above, the search would look like the following:

select * from RM00101 where CUSTNAME like 'O''Brien%'

Note that there are two single quotes between the O and the B.

You can also modify the expression to something like this if you want to either jump to a report or not navigate at all:

This technique can also be used for Bookmark or URL actions, and you can use a SWITCH statement to provide more options.

"Have no fear of change as such and, on the other hand, no liking for it merely for its own sake."

~Robert Moses