dbTalk Databases Forums  

Comparing strings

sybase.public.sqlanywhere.ultralite sybase.public.sqlanywhere.ultralite


Discuss Comparing strings in the sybase.public.sqlanywhere.ultralite forum.

Reply
 
Thread Tools Display Modes
  #31  
Old   
huk
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 09:30 AM






On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com>
wrote:
Quote:
UL version?

--
Chris Keating
9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?





Reply With Quote
  #32  
Old   
huk
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 09:30 AM






On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com>
wrote:
Quote:
UL version?

--
Chris Keating
9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?



Reply With Quote
  #33  
Old   
huk
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 09:30 AM



On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com>
wrote:
Quote:
UL version?

--
Chris Keating
9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?



Reply With Quote
  #34  
Old   
huk
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 09:30 AM



On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com>
wrote:
Quote:
UL version?

--
Chris Keating
9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?



Reply With Quote
  #35  
Old   
Chris Keating
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 04:05 PM



Please post the schema and sample query that you are trying to execute.
--

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:
On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com
wrote:
UL version?

--
Chris Keating

9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?


Reply With Quote
  #36  
Old   
Chris Keating
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 04:05 PM



Please post the schema and sample query that you are trying to execute.
--

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:
On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com
wrote:
UL version?

--
Chris Keating

9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?


Reply With Quote
  #37  
Old   
Chris Keating
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 04:05 PM



Please post the schema and sample query that you are trying to execute.
--

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:
On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com
wrote:
UL version?

--
Chris Keating

9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?


Reply With Quote
  #38  
Old   
Chris Keating
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 04:05 PM



Please post the schema and sample query that you are trying to execute.
--

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:
On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com
wrote:
UL version?

--
Chris Keating

9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?


Reply With Quote
  #39  
Old   
Chris Keating
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 04:05 PM



Please post the schema and sample query that you are trying to execute.
--

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:
On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com
wrote:
UL version?

--
Chris Keating

9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?


Reply With Quote
  #40  
Old   
Chris Keating
 
Posts: n/a

Default Re: Comparing strings - 11-21-2008 , 04:05 PM






Please post the schema and sample query that you are trying to execute.
--

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:
On 21 Lis, 14:27, Chris Keating <keating_spam_f... (AT) ianywhere (DOT) com
wrote:
UL version?

--
Chris Keating

9.0.2.3687

Ok, i realized that this column is long varchar. So, my next question
- how to convert int for example to char with fixed size, and compare
with other string?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.