Microsoft Logo

Microsoft SQL Sample Code

Using the Left & Right Functions

The Left & Right functions are very useful for getting the portion of a string that is the left or right number of characters that you specify of a main string. Sometimes you need to get a portion of a string at the beginnig or the end of a string - for example you may need to get the characters that are the left 4 or right 4 of a string. This sample script will show you how to accomplish this.

Truncate Table

If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.

About Us

WSI is a small business and a leading provider of custom SQL Server/Azure programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom SQL Server/Azure development experts.