query check field which has a _

[eyeseetee]

Hi How can i run a query which will check that there is _ in the field name? cheers

[Imran Adam]

You could try and use the IsPunctuation method to check for a '_'.

Cheers :)

[pmarfleet]

Read the documentation[^] under the section 'Using Wildcards as Literals'.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[eyeseetee]

hi i need it to work when running it in c# e.g. string test0002 = "Select room_code from room_types where room_code like '_'"; but this doesnt work it seems to only look for a field called _ not containing this character?? any suggestions? cheers

[pmarfleet]

hustler2005 wrote:

You could try and use the IsPunctuation method to check for a '_'.

How does that answer the question :confused: Read my response[^].

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[pmarfleet]

Did you read the documentation under the section I mentioned?

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush