In a table called
pacientes I have a
Juan , which is
varchar (4) .
if has the following inconvenience
Juan can be
José . That is, this name can vary many times I need a
IF that enters
Select shows result.
IF shows I believe only alpha-numeric in
I want that if
select shows 'X' of result between
Begin , what I had will be something like this
IF (SELECT Nombre FROM Tabla WHERE CEDULA)>0 BEGIN PRINT 'Entro' END ELSE PRNT 'NO ENTRO'
Understand that for me I think that
>0 "Greater than 0" does it mean Show amount of Rows Shown or am I wrong? Or does it show if the number of
select is greater then enter?
How would it be written correctly?
I did this #Temp (Temporary Table) to see how it was but it did not work.
CREATE TAble #Temp ( NOMBRE varchar (250) ) INSERT #Temp Values ('Juan'); IF (SELECT Nombre FROM #temp)>0 BEGIN PRINT 'EXITO' END ELSE PRINT 'NO EXISTE'
Very important the word
juan are combinations of the A-Z osea thousands of combinations
I want a solution to the line
IF (SELECT Nombre FROM #temp)>0
this is taken as varchar and not as int