Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenate the " sign

Status
Not open for further replies.

sshafe

Programmer
Oct 18, 2002
71
US
Dumb question...

How do you concatenate the " into a string?

Thanks in advance...
 
you so you can have a string with " in it? If so like this; ""
 
see thread329-653071

Posting code? Wrap it with code tags: [ignore]
Code:
[/ignore][code]CodeHere
[ignore][/code][/ignore].
 
you could also use the
Code:
chr(34)
character.

Example:
Code:
strExample = chr(34) & "This will be in quotes" & chr(34)
Wscript.Echo strExample

Hope this helps!


------------------------------------------------------------------------------
nobody knows everything about IT, so make a point to help your fellow members

-= j@ckle =-
 
It does answer that question, but it still didn't fix the problem like I was hoping.

Here's the problem:
I am looping through a recordset of database names inside sql server. On each recordset, I am issuing the
Use "database"
command. I run into a problem when I encouter a database with a . in the name. I am assuming the script is taking this as a db qualifier. That's why I tried putting the quotes around. (It worked in query analyzer)

Any ideas how to fix?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top