Ultralite Project query

Hi - 

I need to add a Sybase statement to the Ultralite project that reads -

SELECT Name FROM Table WHERE Name LIKE '%abc%' 

where abc needs to be passed in at runtime in the placeholder ?. 

Can the above query be entered as:

SELECT Name FROM Table WHERE Name LIKE '%?%' 

Will this work?

Please help me,
Thanks,
preeti


0
preeti
2/7/2003 5:15:41 PM
sybase.sqlanywhere.mobilink 5254 articles. 0 followers. Follow

2 Replies
446 Views

Similar Articles

[PageSpeed] 42

preeti wrote in news:22498C8C06CE1580005ED1EB85256CC6.005ED1FB85256CC6
@webforums:

> SELECT Name FROM Table WHERE Name LIKE '%?%' 

No, I think you would do this:
SELECT Name FROM Table WHERE Name LIKE ?

Then when you supply the parameter when you open the statement you would
do this:
.....setColumn("%Dave%") 

--
David Fishburn
NEW - Certified ASA Developer Version 8
Sybase - iAnywhere Solutions
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with EACH
post (dbeng8 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm 

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com


0
David
2/7/2003 7:57:23 PM

    
0
preeti
2/10/2003 3:26:38 AM
Reply: