Invalid length parameter passed to the LEFT or SUBSTRING function

by

That would only happen if PostCode is missing a space.
You could add conditionality such that all of PostCode is retrieved should a space not be found as follows

select SUBSTRING(PostCode, 1 ,
case when  CHARINDEX(' ', PostCode ) = 0 then LEN(PostCode) 
else CHARINDEX(' ', PostCode) -1 end)

Related Contents:

  1. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  2. How to restore to a different database in SQL Server?
  3. How to connect to local instance of SQL Server 2008 Express
  4. How to check date of last change in stored procedure or function in SQL server
  5. Enable ‘xp_cmdshell’ SQL Server
  6. A transport-level error has occurred when receiving results from the server [closed]
  7. optional parameters in SQL Server stored proc?
  8. Export query result to .csv file in SQL Server 2008
  9. How to convert float to varchar in SQL Server
  10. “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine” Error in importing process of xlsx to a sql server
  11. SQL Add foreign key to existing column
  12. How to edit one specific row in Microsoft SQL Server Management Studio 2008?
  13. Add column to SQL Server
  14. Why use the SQL Server 2008 geography data type?
  15. What does “select 1 from” do?
  16. How to declare an array inside MS SQL Server Stored Procedure?
  17. Adding an administrator user to SQL Server 2008
  18. “” is not a valid login or you do not have permission” on sql server installation
  19. SQL Server Files Local or NAS or SAN?
  20. Activity monitor is unable to execute queries against server
  21. How can I see who is connected to my db?
  22. How can I have SQL Server Management Studio 2008 connect to my instances automatically?
  23. Optional parameters in SQL Server stored procedure
  24. varchar(max) everywhere?
  25. How to add hours to current date in SQL Server?
  26. How to install SQL Server Management Studio 2008 component only [closed]
  27. Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AI” in the equal to operation
  28. How to re-seed a table identity in SQL Server 2008 and undo it all safely?
  29. SQL MERGE statement to update data
  30. Where are SQL Server connection attempts logged?
  31. How to check if datetime happens to be Saturday or Sunday in SQL Server 2008
  32. Text was truncated or one or more characters had no match in the target code page When importing from Excel file
  33. Win32Exception (0x80004005): The wait operation timed out
  34. Getting error while running 50 MB script on SQL Server 2008 R2
  35. Auto-increment primary key in SQL tables
  36. How would one use Lucene.NET to help implement search on a site like Stack Overflow?
  37. How many characters in varchar(max)?
  38. What is the default transaction isolation level for SQL Server with ADO.NET?
  39. Does the size used with NVARCHAR matter?
  40. how to rename column name with T-SQL
  41. ALTER TABLE on dependent column
  42. Invalid object name SQL Server 2008 R2 – Stored procedure
  43. What is the use of SYNONYM?
  44. storing passwords in SQL Server
  45. Reporting Services permissions on SQL Server R2 SSRS
  46. T-SQL substring – separating first and last name
  47. “Primary Filegroup is Full” in SQL Server 2008 Standard for no apparent reason
  48. how to create and call scalar function in sql server 2008
  49. T-SQL: Export to new Excel file
  50. How to deploy SQL Server Compact Edition 4.0?

Leave a Comment