Sql-server – Query To Return Values Where NOT All Text

sql serversql-server-2008-r2t-sql

I have a field that is varchar(100) – if the field is all text, I want to ignore it, if it is alpha-numeric I want to return the data. This is sample DDL and my ISNUMERIC() excludes both values (I assume because they contain text with the numbers).

How should this be altered in order to return any value that is not just text?

Declare @Table Table (field1 varchar(100))
Insert Into @Table Values 
('1ZCLJKSDFLKSJDF'), 
('0301190XFS3'), 
('Pink Socks Run Free'), 
('White Goats Stink')

Select * from @table where ISNUMERIC(field1) >= 1

Best Answer

Fairly simple:

Select * from @table where field1 LIKE '%[0-9]%'

Related Solutions

Sql-server – Full-text search in SQL Server on multiple tables fails

Hi we can query multiple tables in a full-text search by using views ,but we some advantages and disadvantages . Here in your case you created view dbo.vw_recipe_search it seems your are not using it in altered procedure when i query it i am getting results as per intended

  SELECT *
        FROM dbo.vw_recipe_search r 
        INNER JOIN FREETEXTTABLE(vw_recipe_search, *, 'salsa peas') kt
            ON r.search_id = kt.[KEY]
        ORDER BY RANK DESC;

The problem in this approach is ranking and weightage of each column , like suppose if u want to give high weight to title column than descrip you have to do a lot of work in order by rank column . We used Levenstein string comparision function to order for better results set

Sql-server – SSIS keeps force changing excel source string to float

Is it possible to get the file as a .csv file which can be imported like a text file and will not have this problem? I generally kick back all Excel files and ask for another format because SSIS and Excel do not play well together on many levels.

Best Answer

Related Solutions

Sql-server – Full-text search in SQL Server on multiple tables fails

Sql-server – SSIS keeps force changing excel source string to float

Related Question