DECLARE @string varchar(100)

SET @string = '12345 Test Address Dr.'

SELECT LEFT(@String,CHARINDEX(' ', @string))

OK, so can you define in English exactly what you want?  Are you looking for all numeric characters prior to the first blank character ' '?  Or all numeric characters...

I'm sure you will find as many methods to do this as there are developers/DBAs, but this should work for you.  Feel free to put this into a UDF for...

From a command prompt, run bcp -v to get your version number.  Please post it.

If you are running SQL Server on any account other than the system account, make sure that you've granted that user the 'lock pages in memory' right.

That's a first!  Well, you beat me to post # 3709.....

I agree Remi, the likeliness of this being a joke is quite high and Adam’s advice is not advice at all.  I guess I just...

Let's all continue this in the other thread please as it seems to be more productive.

Adam,

I'm just curious here but why would he need to re-install SQL Server if he's only effected a user table?  I can see if he were to have deleted...

Please see my post in your other thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=389804

Ryan,

Although what you are attempting to do here is quite shocking, I’m not sure that deserves a...

Terrence,

Your query may produce unwanted results.  First of all, you don't need the self-join.  How do I know this?  Well, you are not using table B for any reason...

Well, I totally agree with you assessment from your #2 in that since there is no CI and therefore no direct link to the data page, SQL Server scans...

Well, if there are 3 addresses for the client, your query will return the client data along with the 3 different addresses, but I would not consider this duplicate data. ...

Have you given my query a shot yet?