Yes you are right about there being a business need to concatenate.

I misread his question but since the values are numbers that are being concatenated I was wondering about the...

Gosta,

It turns out that I belonged to that list when I was converting Lotus Notes to Excel for a Year 2K Project (12 years ago).

Thanks Gosta.

By chance do you when you create a new connection to SQL Server how do you specify where the connection is used?

I tried defining a range and I get...

Well thank you and I'm sorry for not thanking you and others.

Please accept my apology. :blush:

I mentioned...

Thanks again Gail.:-)

Sorry but what you are doing is not usual or customary.

If you want to execute the code then it should not be in the after update event code.

Generally an after...

It is relative simple to pass parameters or a collection of to a Stored Procedure.

Basally assign the values of the form controls and Execute the SP with the parameters.

I have...

Dev (11/29/2011)

---

The US Congress is considering America's first system for censoring the Internet. Despite public outcry, the Internet Censorship bill could pass at any time. If it does,...

Thanks Brandie.

I had to put this on the back burner because my priorities have changed but SA is the only Account that is a member of the sysadmin role.

Thanks!

sp_helpsrvrolemember

ServerRoleMemberNameMemberSID

sysadminsa...

?

...

...

Thank you for correcting me!

stebennettsjb (1/1/2012)

---

Hi all,

simple one for you experts im sure. I have a table with values in col1 and col2

I want to put both values into a new col with...