[RESOLVED] [2005] dataset query with @ literal

[MaslowB]

I have a query that actually needs to use an @ sign in a literal ... where lastName not like '@%'. of course .net thinks this is supposed to be a parameter, is there a way to do this in the table adapter designer?

I'm looking for data where the lastname does not start with an @ sign, and would like to build a dataset off of this.

[Kasracer]

I think you can use the escape characters to do that. I can't remember the syntax for VB.Net but I think it's something like this:

WHERE lastName NOT LIKE '"@%'

Alternatively Chr(64) may work.

[Deepak Sakpal]

Use Chr(Asc("@"c)) like this:

MessageBox.Show("""" & Chr(Asc("@"c)) & "%""")

[MaslowB]

I think you can use the escape characters to do that. I can't remember the syntax for VB.Net but I think it's something like this:

WHERE lastName NOT LIKE '"@%'

Alternatively Chr(64) may work.

This appears to work, thank you!

[MaslowB]

Use Chr(Asc("@"c)) like this:

MessageBox.Show("""" & Chr(Asc("@"c)) & "%""")

This doesn't work in the designer, the other post worked though.