 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Alain Bastien
Guest
|
 Posted: Mon Dec 20, 2004 2:34 pm Post subject: LIKE % in Parametrized Result set Stored Procedures |
 |
|
Hi,
RE:LIKE % in Parametrized Result set Stored Procedures
In TQuery it works but not stored procedures
How to code it in a stored procedure?
select s_lname,s_fname, s_userid from table
where name like :searchname
| Quote: | where 'searchname' could be the character and a % and the end
|
--
Alain
|
|
| Back to top |
|
 |
Mauricio A MIRET
Guest
|
| Posted: Sat Apr 16, 2005 5:20 pm Post subject: Re: LIKE % in Parametrized Result set Stored Procedures |
|
|
when you complete the param you can do
sp->ParamByNAme('SEARCHNAME')-> AsString = letter + '%';
or
String S = letter + "%";
sp->ParamByNAme('SEARCHNAME')-> AsString = S;
HTH
MAM
"Alain Bastien" <alain_bastien (AT) mydodo (DOT) net> escribió en el mensaje
news:41c6e32f (AT) newsgroups (DOT) borland.com...
| Quote: | Hi,
RE:LIKE % in Parametrized Result set Stored Procedures
In TQuery it works but not stored procedures
How to code it in a stored procedure?
select s_lname,s_fname, s_userid from table
where name like :searchname
where 'searchname' could be the character and a % and the end
--
Alain
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
