I need to write a SQL query to filter out some records. I need all records that start with "MED" and are 8 characters long. something along the lines of: select * from TABLE where len(RECORD) = 8 and Begins with "MED" Urgent! Thanx!!!
|How to base a filter depending on fields contents?||15||57|
|convert in derived column||7||30|
|SQL Server - Set Field Values ito Zero Based on Related Table||4||27|
|SQL Syntax: How to force case sensitive query?||2||30|