on 10-28-2005 8:51 AM
Hi,
ive problem with SQlstoredprocedure...
i have one like this:
CREATE PROCEDURE dbo.test
@in_surname char(255),
@surname char(255) OUTPUT,
@name char(255) OUTPUT,
@subsidiaries char(255) OUTPUT,
@dep_position char(255) OUTPUT,
@phone_number char(255) OUTPUT,
@fax_number char(255) OUTPUT,
@email char(255) OUTPUT
AS
SELECT @in_surname = RTRIM(@in_surname) + '%'
SELECT MyLegal_User.* FROM MyLegal_User
WHERE MyLegal_User.surname LIKE @in_surname
GO
but the problem is that the LIKE doesnt work correctly.. only values are given back that match exact the value given in input form..
does anyone know what is the problem?
Thanks for help!!
Karol
ok.. sorry.. the fields were wrong defined
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.