Search code examples
sqlsql-serverstringstrippostgresql

sql server strip string

I have a table in SQL Server of strings that i need to inner join to another table that contains some similarity between substrings, here i have an example: Intel Atom CPU N450 @ 1.66GHz (INNER JOIN) Intel Atom N450@ 1.66GHz . I dont want use replace, i was thinking in something like using substring, pad, or something else. For example i wish to look for 'N450' on the other table. Could someone help me?

Solution

  • Check out CharIndex if you want to look for something in SQL Server.

    Example:

    Select * from YourTable where CharIndex('YourString', YourColumn) > 0

    Relevant: http://msdn.microsoft.com/en-us/library/ms186323.aspx