Query to select passwords from a table having a column "Password" Who

Query to select passwords from a table having a column
"Password" Whose length is b/w 8 &15 and having 'A' as the
first character in the password irrespective of case.

Question Posted / ramesh

3 Answers
5407 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &..

Answer / mdeva

SELECT Password
FROM tablename
WHERE Password LIKE 'A%'
AND Length( Password) >=8
AND Length( Password) <=15

Is This Answer Correct ?

15 Yes

3 No

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &..

Answer / owais masood

select password from tablename
where (password like "A%" AND length(password) between 8 and
15) OR
(password like "a%" AND length(password) between 8 and 15)

Is This Answer Correct ?

12 Yes

0 No

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &..

Answer / sonali

select password from tablename
where password like 'a%'
and length(password) between 8 and 15

Is This Answer Correct ?

2 Yes

1 No

Post New Answer