在不选择第一个字符时尝试选择字段时出错

Question

I'm getting the error: Incorrect syntax near the keyword 'AS'. I'm trying to select a column from my MSSQL database while NOT SELECTING the first character of that field. Below is the code (Within PHP):

$sql = "SELECT RIGHT(Column, LEN(Column) - 1) FROM Table WHERE [Column] ='".$search."' AS Column2";

Answer 1

try this:

    $sql = "SELECT RIGHT(Column, LEN(Column) - 1) AS Column2 FROM Table WHERE [Column] ='".$search."' ";