title: Getting error "Invalid length parameter passed to the LEFT or SUBSTRING function"
body: <p>I have few questions in  the below query, the last name line when I uncomment and run the whole query it returns with the error:</p>
  
  <blockquote>
    <p>Invalid length parameter passed to the LEFT or SUBSTRING function</p>
  </blockquote>
  
  <p>And how can I remove Hyphen in postal zip code, below is the code:</p>
  
  <p>Last when I add last name line it gives me this error </p>
  
  <blockquote>
    <p>Invalid length parameter passed to the LEFT or SUBSTRING function</p>
  </blockquote>
  
  <p>And below I want to remove  anything after dashes in zip code like example (99297-9925)-- here I want to remove "-9925"-- only few records exist like this:</p>