Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql server remove 0 from left

  SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))
Comment

PREVIOUS NEXT
Code Example
Sql :: mysqldump 1 table only 
Sql :: get current date sql 
Sql :: alter boolean column postgresql 
Sql :: change database postgres 
Sql :: SQL Server run query on linked server 
Sql :: union postgresql 
Sql :: distinct in sql 
Sql :: if else sql 
Sql :: mysql like 
Sql :: list mysql tables and views 
Sql :: mysql date_format 
Sql :: postgresql delete cascade 
Sql :: sql or 
Sql :: what is unique key in sql 
Sql :: sql rename column in select 
Sql :: faire la différence entre deux tables sql big query 
Sql :: postgresql find blocked query 
Sql :: sql select rows with simlar names 
Sql :: compare field sql server 
Sql :: top frequency in sql server 
Sql :: mariadb search columns 
Sql :: split string and copy last element postgresql 
Sql :: update from select postgresql 
Sql :: oracle synonym procedure 
Sql :: mysql join column order By and group By 
Sql :: cast as decimal postgresql 
Sql :: select all columns except one sql 
Sql :: insert ip address in mysql 
Sql :: rename view mysql 
Sql :: get first match in each group mysql query 
ADD CONTENT
Topic
Content
Source link
Name
3+8 =