Comparing strings

#1

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#2

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#3

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#4

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#5

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#6

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#7

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#8

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#9

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?

#10

UL version?

--
Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

huk wrote:

Quote:

Hi, i have a simple query:
SELECT * FROM product WHERE symbol like '%';

And it returns empty set.
Query
SELECT * FROM product
without WHERE part, returns a lot of data.
What am i doing bad?