Login    
 
 
 
 
Text/HTML
  
You are here :: Blogs Saturday, May 19, 2012

Search
Note: This uses the internal blog search engine. The Google search engine is also available at the top of the page.
  
Disclaimer

Please review the site disclaimer before downloading or using content found on this site

  
Categories
  
DEVSHED Blog
As always, I welcome your comments!
Apr 13

Written by: Steve Gray
4/13/2010 11:58 AM  RssIcon

This snippet will tell you if a SQL field (or variable) contains an alpha character. Remember that in most cases, SQL is not case sensitive

Code Snippet
  1. if @VCHRNMBR like '%[a-z]%' begin
  2.     return @vchrnmbr
  3. end

Tags:
Categories:
Location: Blogs Parent Separator DEVSHED Blogs Child Separator SQL
As always, I welcome your comments!
  
 
 
Home | Products | Blogs | Contact Us | Links | God's Plan
Privacy Statement | Terms Of Use
 
Copyright 2011 by Devshed.us