MapInfo Pro

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)

Hi Alexis,

You can use the following expression in the Where clause:

hydroname in ("ALEXANDER", "ANVIL")

Another option is to use the following:

hydroname = "ALEXANDER" Or hydroname =  "ANVIL"

(Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL")

Wildcards are also possible, if using the "like" operator; e.g. to select all records where hydroname begins with "ALEX":

hydroname like "ALEX%"

I hope this helps.

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)

HI James,

I've tried your methods, but was unable to make it work. So, I decided to use another data set but still unable to work.

I tried:

hydroname like "APPLETREE%" Or hydroname like  "AYRES%"   

And tried:

hydroname = "APPLETREE" Or hydroname = "AYRES%"   

Both came back with an error: "No Records were selected"

Can you spot an error in my methods? or provide a different solution

Im using mapinfo pro version 15.0.3 release build 404

Hi Alexis,

You can use the following expression in the Where clause:

hydroname in ("ALEXANDER", "ANVIL")

Another option is to use the following:

hydroname = "ALEXANDER" Or hydroname =  "ANVIL"

(Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL")

Wildcards are also possible, if using the "like" operator; e.g. to select all records where hydroname begins with "ALEX":

hydroname like "ALEX%"

I hope this helps.

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)

I restarted my mapinfo, and now it works!

Thanks James

HI James,

I've tried your methods, but was unable to make it work. So, I decided to use another data set but still unable to work.

I tried:

hydroname like "APPLETREE%" Or hydroname like  "AYRES%"   

And tried:

hydroname = "APPLETREE" Or hydroname = "AYRES%"   

Both came back with an error: "No Records were selected"

Can you spot an error in my methods? or provide a different solution

Im using mapinfo pro version 15.0.3 release build 404

Hi Alexis,

You can use the following expression in the Where clause:

hydroname in ("ALEXANDER", "ANVIL")

Another option is to use the following:

hydroname = "ALEXANDER" Or hydroname =  "ANVIL"

(Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL")

Wildcards are also possible, if using the "like" operator; e.g. to select all records where hydroname begins with "ALEX":

hydroname like "ALEX%"

I hope this helps.

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)

Hi James,

The following worked: hydroname in ("ALEXANDER", "ANVIL")

However, is there a way to combine it for wildcards?

I've tried: hydroname like ("ALEXANDER%", "ANVIL%")

but it said syntax error and didnt work.

Alex

I restarted my mapinfo, and now it works!

Thanks James

HI James,

I've tried your methods, but was unable to make it work. So, I decided to use another data set but still unable to work.

I tried:

hydroname like "APPLETREE%" Or hydroname like  "AYRES%"   

And tried:

hydroname = "APPLETREE" Or hydroname = "AYRES%"   

Both came back with an error: "No Records were selected"

Can you spot an error in my methods? or provide a different solution

Im using mapinfo pro version 15.0.3 release build 404

Hi Alexis,

You can use the following expression in the Where clause:

hydroname in ("ALEXANDER", "ANVIL")

Another option is to use the following:

hydroname = "ALEXANDER" Or hydroname =  "ANVIL"

(Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL")

Wildcards are also possible, if using the "like" operator; e.g. to select all records where hydroname begins with "ALEX":

hydroname like "ALEX%"

I hope this helps.

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)

Hi James,

The following worked: hydroname in ("ALEXANDER", "ANVIL")

However, is there a way to combine it for wildcards?

I've tried: hydroname like ("ALEXANDER%", "ANVIL%")

but it said syntax error and didnt work.

Alex

I restarted my mapinfo, and now it works!

Thanks James

HI James,

I've tried your methods, but was unable to make it work. So, I decided to use another data set but still unable to work.

I tried:

hydroname like "APPLETREE%" Or hydroname like  "AYRES%"   

And tried:

hydroname = "APPLETREE" Or hydroname = "AYRES%"   

Both came back with an error: "No Records were selected"

Can you spot an error in my methods? or provide a different solution

Im using mapinfo pro version 15.0.3 release build 404

Hi Alexis,

You can use the following expression in the Where clause:

hydroname in ("ALEXANDER", "ANVIL")

Another option is to use the following:

hydroname = "ALEXANDER" Or hydroname =  "ANVIL"

(Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL")

Wildcards are also possible, if using the "like" operator; e.g. to select all records where hydroname begins with "ALEX":

hydroname like "ALEX%"

I hope this helps.

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)

Alexis,

You would have to use:

wherer hydroname like "ALEXANDER%" OR hydroname like "ANVIL%"

You would have to keep adding OR statements for each value you want.

Also note that with the % wildcard at the end the value would need to start with ALEXANDER and then can have anything after that. If you also want records where ALEXANDER is anywhere within the value you would use like "%ALEXANDER%".

Hi James,

The following worked: hydroname in ("ALEXANDER", "ANVIL")

However, is there a way to combine it for wildcards?

I've tried: hydroname like ("ALEXANDER%", "ANVIL%")

but it said syntax error and didnt work.

Alex

I restarted my mapinfo, and now it works!

Thanks James

HI James,

I've tried your methods, but was unable to make it work. So, I decided to use another data set but still unable to work.

I tried:

hydroname like "APPLETREE%" Or hydroname like  "AYRES%"   

And tried:

hydroname = "APPLETREE" Or hydroname = "AYRES%"   

Both came back with an error: "No Records were selected"

Can you spot an error in my methods? or provide a different solution

Im using mapinfo pro version 15.0.3 release build 404

Hi Alexis,

You can use the following expression in the Where clause:

hydroname in ("ALEXANDER", "ANVIL")

Another option is to use the following:

hydroname = "ALEXANDER" Or hydroname =  "ANVIL"

(Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL")

Wildcards are also possible, if using the "like" operator; e.g. to select all records where hydroname begins with "ALEX":

hydroname like "ALEX%"

I hope this helps.

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)

Thanks Sean,

That worked well.

With regards to this:
"Also note that with the % wildcard at the end the value would need to start with ALEXANDER and then can have anything after that. If you also want records where ALEXANDER is anywhere within the value you would use like "%ALEXANDER%".   "

Where would this come in handy? Do you have an example. Keen to try this out.

Alex

Alexis,

You would have to use:

wherer hydroname like "ALEXANDER%" OR hydroname like "ANVIL%"

You would have to keep adding OR statements for each value you want.

Also note that with the % wildcard at the end the value would need to start with ALEXANDER and then can have anything after that. If you also want records where ALEXANDER is anywhere within the value you would use like "%ALEXANDER%".

Hi James,

The following worked: hydroname in ("ALEXANDER", "ANVIL")

However, is there a way to combine it for wildcards?

I've tried: hydroname like ("ALEXANDER%", "ANVIL%")

but it said syntax error and didnt work.

Alex

I restarted my mapinfo, and now it works!

Thanks James

HI James,

I've tried your methods, but was unable to make it work. So, I decided to use another data set but still unable to work.

I tried:

hydroname like "APPLETREE%" Or hydroname like  "AYRES%"   

And tried:

hydroname = "APPLETREE" Or hydroname = "AYRES%"   

Both came back with an error: "No Records were selected"

Can you spot an error in my methods? or provide a different solution

Im using mapinfo pro version 15.0.3 release build 404

Hi Alexis,

You can use the following expression in the Where clause:

hydroname in ("ALEXANDER", "ANVIL")

Another option is to use the following:

hydroname = "ALEXANDER" Or hydroname =  "ANVIL"

(Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL")

Wildcards are also possible, if using the "like" operator; e.g. to select all records where hydroname begins with "ALEX":

hydroname like "ALEX%"

I hope this helps.

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)

One example would be if you had records for East Alexander and West Alexander, you could query both with like "%ALEXANDER%".

Thanks Sean,

That worked well.

With regards to this:
"Also note that with the % wildcard at the end the value would need to start with ALEXANDER and then can have anything after that. If you also want records where ALEXANDER is anywhere within the value you would use like "%ALEXANDER%".   "

Where would this come in handy? Do you have an example. Keen to try this out.

Alex

Alexis,

You would have to use:

wherer hydroname like "ALEXANDER%" OR hydroname like "ANVIL%"

You would have to keep adding OR statements for each value you want.

Also note that with the % wildcard at the end the value would need to start with ALEXANDER and then can have anything after that. If you also want records where ALEXANDER is anywhere within the value you would use like "%ALEXANDER%".

Hi James,

The following worked: hydroname in ("ALEXANDER", "ANVIL")

However, is there a way to combine it for wildcards?

I've tried: hydroname like ("ALEXANDER%", "ANVIL%")

but it said syntax error and didnt work.

Alex

I restarted my mapinfo, and now it works!

Thanks James

HI James,

I've tried your methods, but was unable to make it work. So, I decided to use another data set but still unable to work.

I tried:

hydroname like "APPLETREE%" Or hydroname like  "AYRES%"   

And tried:

hydroname = "APPLETREE" Or hydroname = "AYRES%"   

Both came back with an error: "No Records were selected"

Can you spot an error in my methods? or provide a different solution

Im using mapinfo pro version 15.0.3 release build 404

Hi Alexis,

You can use the following expression in the Where clause:

hydroname in ("ALEXANDER", "ANVIL")

Another option is to use the following:

hydroname = "ALEXANDER" Or hydroname =  "ANVIL"

(Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL")

Wildcards are also possible, if using the "like" operator; e.g. to select all records where hydroname begins with "ALEX":

hydroname like "ALEX%"

I hope this helps.

Hi,

I want to be able to find multiple texts e.g. "ALEXANDER" AND "ANVIL" out of 7000 lines of record. But I am unable to figure out the syntax for this. 

Anyone able to help? (Picture attached)