Sorguda gelen değer numerik mi değil mi?

http://stackoverflow.com/questions/6345687/select-from-col-where-name-null-name-is-an-int-sql-problem

SELECT * FROM col WHERE NOT name IS NOT NULL AND name NOT LIKE '%[^0-9]%'

SELECT * FROM col WHERE NOT name IS NOT NULL AND ISNUMERIC(name) = 1

For SQL server this is the Syntax:

SELECT * FROM col WHERE NOT name IS NULL AND ISNUMERIC(name) = 1 AND NOT name LIKE '%.%'


If you use MSSQL, SELECT * FROM col WHERE name <> 'NULL' AND IsNumeric(name) = 1





            
            

                

                    

                        

                            

                                

                                                                    
                            
                            

                                

                                                                            

                                            
About Post Author
                                        
                                                                        

                                        
                                            Sayfa Yoneticisi                                        
                                    
                                                                                                                                                                                
                                

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                            
                        
                    
                
            
                    

            

                
                

                    
                        
                    
                    

                        Happy                    
                    

                                                    0
                        
                                                0 %
                                            
                

                

                    
                        
                    
                    

                        Sad                    
                    

                                                    0
                                                                        0 %
                                            
                

                

                    
                        
                    
                    

                        Excited                    
                    

                                                    0
                                                                        0 %
                                            
                

                

                    
                        
                    
                    

                        Sleepy                    
                    

                                                    0
                        
                                                0 %
                                            
                

                

                    
                        
                    
                    
Angry
                    

                                                    0
                                                                        0 %
                        
                    
                

                

                    
                        
                    
                    
Surprise
                    

                                                    0
                                                                        0 %