Recent content by adhoustonj

How many potatoes does it take to kill an Irishman?

What do you call a prostitute with a runny nose?

Post the SQL and let us help. Is your db contained into one file, split between FRONT END and BACK END - and if so, is the BE still an accdb file?

Hmmm... I did see something along the lines of checking once string character is number, keep reading next string value if numeric, else if last value was numeric, insert pipe | operator, then after reading entire string, replace all non [0-9] characters with " ", then replace " " with "", or...

And i ask because it seemed the most difficult part was determining the last number in its entirety versus being the only number… i don’t have my pc to test anything right now, but as much as this has itched my noggin, you have me just as curious as to the details i was asking about in the post...

Hey Isaac, could you specify the below a little more? Like how are these columns populated, are you populating the columns, are you importing the data into columns, etc…. I guess i ask also because sometimes it seems you have one number or two… i’ll see what i can come up with.. asdf asdf #...

Here is an updated answer that should work for you. And no ambiguity on your part - it is my Friday afternoon brain fog! Reverse was a new one for me. I have never had to use it in T-SQL string manipulation before. DECLARE @stringvalue varchar(max) = 'asdf asdf 2222 # to 744 # asdf asdf asdf'...

If you you mean actual numbers then 1 or 2 would work, if you do mean #'s then 3 or 4. ---EDIT: UNSOLVED.... I need to fix #1 DECLARE @stringvalue varchar(max) = 'asdf asdf 2 # to 74 # asdf asdf asdf' SELECT CASE WHEN PATINDEX('%[0-9]%', @stringvalue) = 0 THEN NULL ELSE...

Some ODBC drivers can also be bit specific. I have to connect to an older IBM database and the only driver my IT could find was 32 bit. When I got a new 64 bit laptop, they gave me 64 bit Office, but I had to change it back to 32 bit Office just to be able to still connect to the IBM db via the...

I do want to say @Isaac that I appreciate your words of wisdom. As far as I am concerned, there is no room for justification of any actions

I'm far from Anti-Israeli.. I have a problem with selective outrage and selective condemnation. War is hell. We should be better. And there is no reason not to be, for the greater good of mankind.

If anyone wants to see the truth - I'll show you what is really going on every day, right here. It is all okay for us to come in here and talk about it, clutch our opinions, converse, go back and forth.... Want to see? If it is okay for us to talk about it openly, it must be okay to see what we...

I mean have you also seen the videos of Israeli's beating on prison walls because they were denied their privilege to ra** the Palestinian prisoners? Or the video of the Israeli soldiers raping Palestinian prisoners behind shields? Disgusting. Israel has dropped more tonnage of bombs on Gaza...

One good use is if you have a lot of SQL database changes to make. Rather than hardcoding table names in a script, you can have the names of the objects in a table, and then iterate through to perform whatever truncate, copy, call sp's, etc. for each object name value in the table.

Understood. I hope this didn't come across as needing to be posted in Site Complaints instead of Site Suggestions - I only asked out of curiosity, and maybe I shouldn't even be asking this question here. It is almost like searching inside a database on your local machine from windows explorer...