A simple varchar comparison

xErath · #1 (**permalink**) 01-05-05, 12:01

First, Hi to all I'm new to this forum.
Second, I don't know if standard SQL involves stored procedures, but anyway I'll post my doubt.
I have chessy little procedure to get a password from a login. login is a varchar

CREATE PROCEDURE getPassw
@login as varchar
AS
SELECT T_Worker.pass
FROM T_Worker
WHERE T_Worker.login = @login

If I try " exec getPassw 'abc' ", I never get anything. The data exists in the tables. If I do something like

CREATE PROCEDURE getPassw
/*@login as varchar*/
AS
SELECT T_Worker.pass
FROM T_Worker
WHERE T_Worker.login = 'abc'

The password shows up : '456' .
If I remove the '@' from the WHERE query, all columns are returned... ?!?!?

I running the commands on a Microsoft's SQL server. Thank you for your attention. Any help would be seriously apreciated.

Pat Phelan · #2 (**permalink**) 01-05-05, 13:44

This post really belongs in the Microsoft SQL forum.

I think the only problem is that you didn't cut yourself enough rope... You need to make the parameter longer, like:

Code:

CREATE PROCEDURE getPassw 
   @login as varchar(50)
AS

SELECT T_Worker.pass
   FROM T_Worker
   WHERE T_Worker.login = @login

RETURN

-PatP

xErath · #3 (**permalink**) 01-05-05, 15:13

AH!!! Something that simple... But it did work... Sorry not posting this in the right place

Internet Services

Web Development

Digital Marketing

Consumer Tech