Implementing a variable with quotes in SQL

Question

so iam trying to make a sub to get data from an excel sheet and its working good but then i want to set 3 labels when i call a sub and that sub takes 1 parameter as State and iam trying to do "SELECT DC FROM [Data$] WHERE State=""" & State & """" to make a string eg. SELECT DC FROM [Data$] WHERE State="New York"
but it doesnt seem to work well as it gives me a datatable of nothing

Answer 1

Shouldn't you include two double qoutes in new york like ""NEW YORK"" instead of "NEW YORK" ?

Answer 2

I thought that you were supposed to use a single quotes outside the double quotes instead of two sets of double quotes. This would be normal for SQL but it may be different in your situation

Answer 3

its because iam using vb.net for it so if i use ' it gets commented and it looks like when SQL connected to vb.net it can use " or something like that

Answer 4

@Iwan, can you send your message in English please? Russian is not much available here in SoloLearn. Perhaps you try a translation from Google... By the way, welcome here at SoloLearn...

Answer 5

the rest of the code has the final output of the SQL statement like that and its working fine

Answer 6

I am not sure, but it looks like you are missing a set of double quotes...you only have 3 double quotes after State = and you have 4 double quotes at the end.

Answer 7

notice the double quote at the start of the code @Ricky
the reason iam having 3 double quotes before is i searched how to put a double quote in a string and i found out that to do so you need 2 empty strings next to each other which means 4 double quotes but if the quote after a string you just put 2 double quotes after the closing of the string behind it