How To Make Your Website Standout

I've been creating monthly newsletters for CNC Web Solutions  for a year now.  These newsletters have become larger and larger as the months go on and have morphed into more of a magazine as I like to include photos.  So I decided I liked the magazine format and from this month on I will be [...]

By | 2017-01-16T19:20:08+00:00 August 24th, 2013|My Blog|

Get the first part of a string in SQL

Below is a simple example of how to use charindex to break apart a string. SELECT SUBSTRING('FirstName LastName', 1, CHARINDEX(' ', 'FirstName LastName' + ' ')-1) AS OnlyFirstName It's pretty simple as your just using charindex to get the position of the firt instance of a space.  The tricky part here is what if some [...]

By | 2013-08-16T14:08:00+00:00 August 16th, 2013|My Blog|