Question: Got a table with 1200 rows. Added a new column which will contain incremental values -
Candidate1
Candidate2
Candidate3
.
.
.
Candidate1200

What is the best way to insert these values , non manual way. I am using SQL Server 2008

Answer: 
Simple:

```
$post_title = sanitize_title_with_dashes($post_title);

```

But WordPress does this for you already. I assume you need it for something different?
Some solution might be found at <http://postedpost.com/2008/06/23/ultimate-wordpress-post-name-url-sanitize-solution/>

Also, you might want to do it as follows:

```
$special_chars = array("?", "[", "]", "/", "\\", "=", "<", ">", ":", ";", ",", "'", "\"", "&", "$", "#", "*", "(", ")", "|", "~", "`", "!", "{", "}");
$post_name = str_replace(' ', '-', str_replace($special_chars, '', strtolower($post_name)));

```