<div>
Wow, that was really fast! Thanks a lot!!!
</div>


Wow, that was really fast! Thanks a lot!!!

<div>
<div class="content wysiwyg-content">
I need to update Canadian zip codes fields in SQL SErver 2000. Canadian zip is 3 characters + space + 3 characters (7 characters in all).The problem is that there was no validation on our website until today and lots of users entered their zip codes as 6 characters, ie no space after 3rd character. As I am novice, I have no idea how to put space after 3rd character in those zipcodes which were entered without it and don't do anything to those which were entered correctly.<br />
Any help will be greatly appreciated.<br />
Thanks in advance!!!<br />
I have only 50 points to award that questins, kindda not fair:-)
</div>
</div>


I need to update Canadian zip codes fields in SQL SErver 2000. Canadian zip is 3 characters + space + 3 characters (7 characters in all).The problem is that there was no validation on our website until today and lots of users entered their zip codes as 6 characters, ie no space after 3rd character. As I am novice, I have no idea how to put space after 3rd character in those zipcodes which were entered without it and don't do anything to those which were entered correctly.
Any help will be greatly appreciated.
Thanks in advance!!!
I have only 50 points to award that questins, kindda not fair:-)

insert space character in SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.